oracle 索引

SELECT /*+ index(b i2p_pm_prodc_prgs_dtl) */
A.FCT_CODE,
A.PLANT_CODE,
A.PO_NO,
B.MAG_NO,
MIN(B.PRODC_SEQ) KEEP (DENSE_RANK FIRST ORDER BY B.PRODC_SEQ) AS PRODC_SEQ
FROM TB_PM_PROC_PRGS A,
TB_PM_PRODC_PRGS_DTL_PRGS B,
TB_PM_PO_YMD_PLAN C

-------------------------------------

/*+ index(b i2p_pm_prodc_prgs_dtl) */这句话很重要