Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from Oracle to GaussDB/ U0100024: GaussDB does not support hint INDEX_JOIN in Oracle
Updated on 2025-10-22 GMT+08:00
View PDF
Share

U0100024: GaussDB does not support hint INDEX_JOIN in Oracle

Description

GaussDB is not fully compatible with the hint.

Database Type and Version

  • Source database type and version: Oracle versions supported by UGO
  • Target database type and version: GaussDB versions supported by UGO

Syntax Example

SELECT /*+ NO_INDEX (employees emp_department_ix) */        employee_id,
 department_id   FROM employees   WHERE department_id > 50;
SELECT /*+INDEX_JOIN(BSEMPMS SAL_HMI HIREDATE_BMI)*/ SAL,
HIREDATE  FROM BSEMPMS WHERE SAL<60000;

Suggestion

Modify Hint tuning.