sql优化，ordered user_nl() index() 的用法 ，示例 。

除了家索引优化外，可以制定执行索引顺序。 

SELECT /*+ordered use_nl(T DO DD PO PD SZ SA) index(task B)*/
 T.LABEL_CN, T.CUID, C.CIRCUIT_NO,  T.RELATED_ORIG_LOGIC_CUID,
                            DO.LABEL_CN               AS RELATED_ORIG_LOGIC_LABEL,
                            T.RELATED_DEST_LOGIC_CUID,
                            DD.LABEL_CN               AS RELATED_DEST_LOGIC_LABEL,
                            T.RELATED_ORIG_PORT_CUID,
                            PO.LABEL_CN               AS RELATED_ORIG_PORT_LABEL,
                            T.RELATED_DEST_PORT_CUID,
                            PD.LABEL_CN               AS RELATED_DEST_PORT_LABEL,        T.RELATED_Z_SITE,
                            SZ.LABEL_CN             AS RELATED_Z_SITE_LABEL,       T.RELATED_A_SITE,
                            SA.LABEL_CN         AS RELATED_A_SITE_LABEL,         C.END_SWITCH_DEV_A_DDF,
                            C.END_SWITCH_DEV_Z_DDF    FROM T_LOGIC_LINK   T,       T_COM_BTS_CIRCUIT C,
                            T_LOGIC_DEVICE DO,        T_LOGIC_DEVICE DD,        T_LOGIC_PORT   PO,
                            T_LOGIC_PORT   PD,      SITE           SZ,       SITE           SA,
                            T_ENG_RADIO_BTSSITE B    WHERE C.CUID (+) = T.CUID
                        AND DO.CUID(+) = T.RELATED_ORIG_LOGIC_CUID
                        AND DD.CUID(+) = T.RELATED_DEST_LOGIC_CUID
                        AND PO.CUID(+) = T.RELATED_ORIG_PORT_CUID
                        AND PD.CUID(+) = T.RELATED_DEST_PORT_CUID   
                        AND SZ.CUID(+) = T.RELATED_Z_SITE
                        AND SA.CUID(+) = T.RELATED_A_SITE
                        AND T.RELATED_ORIG_LOGIC_CUID (+)= B.FORMAL_TABLE_CUID
                        AND T.RELATED_BMCLASSTYPE_CUID='T_LOGIC_LINK_BTSTRUNK'  
                        AND B.OUT_SHEET_ID='SN-953-110818-30023'