Oracle强制sql走索引

今天我们来说说Oracle强制sql走索引：
例: SELECT /+index(t pk_emp)/* FROM EMP T;

也可通过view强制使用索引：

CREATE OR REPLACE VIEW V_RES_CBA AS
SELECT /*+INDEX(SEG IDX_T_RES_ALLOSEG_ALLOID)*/
   ALLO.ALLOID AS RESID,
   NULL AS AWB, 
   ALLO.ALLOTMENT AS ALLO_ID, 
   DAYS.FDATE +