|
L$13
56 - SEL$13 / RB@SEL$13
58 - SEL$13 / FI@SEL$13
59 - SEL$13 / U@SEL$13
60 - SEL$13 / U@SEL$13
61 - SEL$13 / TS@SEL$13
62 - SEL$13 / TS@SEL$13
63 - SEL$14
64 - SEL$29F99543 / D@SEL$14
65 - SEL$29F99543
69 - SEL$29F99543 / V@SEL$16
70 - SEL$29F99543 / HC@SEL$16
71 - SEL$29F99543 / TS@SEL$16
72 - SEL$29F99543 / TS@SEL$16
73 - SEL$29F99543 / TF@SEL$16
74 - SEL$ADB656C7 / F@SEL$14
75 - SEL$ADB656C7
77 - SEL$ADB656C7 / TS@SEL$19
78 - SEL$ADB656C7 / TS@SEL$19
79 - SEL$ADB656C7 / HC@SEL$19
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.4')
DB_VERSION('11.2.0.4')
ALL_ROWS
OUTLINE_LEAF(@"SEL$C8360722")
MERGE(@"SEL$7286615E")
OUTLINE_LEAF(@"SEL$A731BD80")
MERGE(@"SEL$8A3193DA")
OUTLINE_LEAF(@"SET$2")
OUTLINE_LEAF(@"SEL$2")
OUTLINE_LEAF(@"SEL$10")
OUTLINE_LEAF(@"SEL$11")
OUTLINE_LEAF(@"SEL$12")
OUTLINE_LEAF(@"SEL$13")
OUTLINE_LEAF(@"SET$3")
OUTLINE_LEAF(@"SEL$9")
OUTLINE_LEAF(@"SEL$1")
OUTLINE_LEAF(@"SEL$29F99543")
MERGE(@"SEL$16")
OUTLINE_LEAF(@"SEL$ADB656C7")
PUSH_PRED(@"SEL$14" "F"@"SEL$14" 1)
OUTLINE_LEAF(@"SEL$14")
OUTLINE_LEAF(@"SET$1")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$7286615E")
MERGE(@"SEL$5")
OUTLINE(@"SEL$6")
OUTLINE(@"SEL$8A3193DA")
MERGE(@"SEL$8")
OUTLINE(@"SEL$15")
OUTLINE(@"SEL$16")
OUTLINE(@"SEL$E9CE8D49")
MERGE(@"SEL$07C48A2D")
OUTLINE(@"SEL$14")
OUTLINE(@"SEL$4")
OUTLINE(@"SEL$5")
OUTLINE(@"SEL$7")
OUTLINE(@"SEL$8")
OUTLINE(@"SEL$17")
OUTLINE(@"SEL$07C48A2D")
MERGE(@"SEL$19")
OUTLINE(@"SEL$18")
OUTLINE(@"SEL$19")
NO_ACCESS(@"SEL$14" "D"@"SEL$14")
NO_ACCESS(@"SEL$14" "F"@"SEL$14")
LEADING(@"SEL$14" "D"@"SEL$14" "F"@"SEL$14")
USE_NL(@"SEL$14" "F"@"SEL$14")
NO_ACCESS(@"SEL$1" "D"@"SEL$1")
NO_ACCESS(@"SEL$1" "F"@"SEL$1")
LEADING(@"SEL$1" "D"@"SEL$1" "F"@"SEL$1")
USE_HASH(@"SEL$1" "F"@"SEL$1")
NO_ACCESS(@"SEL$2" "DBA_DATA_FILES"@"SEL$2")
USE_HASH_AGGREGATION(@"SEL$2")
NO_ACCESS(@"SEL$9" "DBA_FREE_SPACE"@"SEL$9")
USE_HASH_AGGREGATION(@"SEL$9")
FULL(@"SEL$13" "RB"@"SEL$13")
INDEX(@"SEL$13" "FI"@"SEL$13" ("FILE$"."TS#" "FILE$"."RELFILE#"))
INDEX(@"SEL$13" "U"@"SEL$13" "I_FILE#_BLOCK#")
INDEX(@"SEL$13" "TS"@"SEL$13" "I_TS#")
LEADING(@"SEL$13" "RB"@"SEL$13" "FI"@"SEL$13" "U"@"SEL$13" "TS"@"SEL$13")
USE_MERGE_CARTESIAN(@"SEL$13" "FI"@"SEL$13")
USE_NL(@"SEL$13" "U"@"SEL$13")
USE_NL(@"SEL$13" "TS"@"SEL$13")
INDEX(@"SEL$12" "FI"@"SEL$12" ("FILE$"."TS#" "FILE$"."RELFILE#"))
INDEX_RS_ASC(@"SEL$12" "RB"@"SEL$12" ("RECYCLEBIN$"."TS#"))
INDEX(@"SEL$12" "TS"@"SEL$12" "I_TS#")
FULL(@"SEL$12" "U"@"SEL$12")
LEADING(@"SEL$12" "FI"@"SEL$12" "RB"@"SEL$12" "TS"@"SEL$12" "U"@"SEL$12")
USE_NL(@"SEL$12" "RB"@"SEL$12")
USE_NL(@"SEL$12" "TS"@"SEL$12")
USE_NL(@"SEL$12" "U"@"SEL$12")
FULL(@"SEL$11" "TS"@"SEL$11")
FULL(@"SEL$11" "F"@"SEL$11")
INDEX(@"SEL$11" "FI"@"SEL$11" ("FILE$"."TS#" "FILE$"."RELFILE#"))
LEADING(@"SEL$11" "TS"@"SEL$11" "F"@"SEL$11" "FI"@"SEL$11")
USE_NL(@"SEL$11" "F"@"SEL$11")
USE_NL(@"SEL$11" "FI"@"SEL$11")
INDEX(@"SEL$10" "FI"@"SEL$10" ("FILE$"."TS#" "FILE$"."RELFILE#"))
INDEX(@"SEL$10" "F"@"SEL$10" "I_TS#")
|