我从百度上搜的例子 8. /*+INDEX(TABLE INDEX_NAME)*/ 表明对表选择索引的扫描方法. 例如: SELECT /*+INDEX(BSEMPMS SEX_INDEX) USE SEX_INDEX BECAUSE THERE ARE FEWMALE BSEMPMS */ FROM BSEMPMS WHERE SEX='M'; USE SEX_INDEX BECAUSE THERE ARE FEWMALE BSEMPMS 是不是要加到 /*+ 与 */ 之间写成这样还有没有效果 SELECT /*+INDEX(BSEMPMS SEX_INDEX) */ SEX_INDEX BECAUSE THERE ARE FEWMALE BSEMPMS FROM BSEMPMS WHERE SEX='M';
8. /*+INDEX(TABLE INDEX_NAME)*/
表明对表选择索引的扫描方法.
例如:
SELECT /*+INDEX(BSEMPMS SEX_INDEX) USE SEX_INDEX BECAUSE THERE ARE FEWMALE BSEMPMS */ FROM BSEMPMS WHERE SEX='M';
USE SEX_INDEX BECAUSE THERE ARE FEWMALE BSEMPMS 是不是要加到 /*+ 与 */ 之间写成这样还有没有效果
SELECT /*+INDEX(BSEMPMS SEX_INDEX) */ SEX_INDEX BECAUSE THERE ARE FEWMALE BSEMPMS FROM BSEMPMS WHERE SEX='M';