/*+ INDEX_ASC(TABLE INDEX_NAME) */
表明对表选择索引升序的扫描方法.
SELECT /*+INDEX_ASC(EMPMS PK_EMPMS) */ * FROM EMPMS WHERE DPT_NO='SCOTT';
/*+ INDEX_DESC(TABLE INDEX_NAME) */
表明对表选择索引降序的扫描方法.
SELECT /*+INDEX_DESC(EMPMS PK_EMPMS) */ *FROM EMPMS WHERE DPT_NO='SCOTT';
表明对表选择索引升序的扫描方法.
SELECT /*+INDEX_ASC(EMPMS PK_EMPMS) */ * FROM EMPMS WHERE DPT_NO='SCOTT';
/*+ INDEX_DESC(TABLE INDEX_NAME) */
表明对表选择索引降序的扫描方法.
SELECT /*+INDEX_DESC(EMPMS PK_EMPMS) */ *FROM EMPMS WHERE DPT_NO='SCOTT';