sql_hint.sql

## Examples of SQL HINT syntax


SELECT  /*+ RULE */  . . . .
FROM    EMP, DEPT
WHERE   . . .


SELECT  /*+ hint text */  . . . .
DELETE  /*+ hint text */  . . . .
UPDATE  /*+ hint text */  . . . .


SELECT  /*+ RULE */  . . . .
FROM    EMP
WHERE   EMP_STATUS = 'PART-TIME'
AND     EXISTS     ( SELECT  /*+ FIRST_ROWS */  'x'
                     FROM    EMP_HISTORY
                     WHERE   EMP_NO = E.EMP_NO
                     AND     EMP_STATUS != 'PART-TIME' )


SELECT  /*+ RULE */  . . . .
FROM    EMP
WHERE   EMP_STATUS = 'PART-TIME'
UNION
SELECT  /*+ ALL_ROWS */  . . . .
FROM    EMP_HISTORY
WHERE   EMP_STATUS != 'PART-TIME'