Oracle 指定索引

/*+index(t,CUX_AP_BALANCE_TEMP_N3) index(aia,AP_INVOICES_U1)*/ 

/*+ leading(MSI,B,MSIB) INDEX(B MTL_MATERIAL_TRANSACTIONS_N3) */

/*+ no_expand index(aida,CUX_AP_INVOICE_DIST_N3) index(rt,RCV_TRANSACTIONS_U1) index(pha,PO_HEADERS_U1)
index(pha,PO_HEADERS_U1)
index( pla,PO_LINES_U1) index(plla,PO_LINE_LOCATIONS_U1) index( rsh, RCV_SHIPMENT_HEADERS_U1)
index(aps,AP_SUPPLIERS_U1) index(assa,AP_SUPPLIER_SITES_U1) */

 

影响索引 

过滤条件最好关联主表

字段类型