|
INDEX(@"SEL$10" "TS"@"SEL$10" "I_TS#")
LEADING(@"SEL$10" "FI"@"SEL$10" "F"@"SEL$10" "TS"@"SEL$10")
USE_NL(@"SEL$10" "F"@"SEL$10")
USE_NL(@"SEL$10" "TS"@"SEL$10")
FULL(@"SEL$A731BD80" "X$KCCFN"@"SEL$8")
FULL(@"SEL$A731BD80" "HC"@"SEL$6")
INDEX(@"SEL$A731BD80" "TS"@"SEL$6" "I_TS#")
INDEX_RS_ASC(@"SEL$A731BD80" "F"@"SEL$6" ("FILE$"."FILE#"))
FULL(@"SEL$A731BD80" "FE"@"SEL$6")
LEADING(@"SEL$A731BD80" "X$KCCFN"@"SEL$8" "HC"@"SEL$6" "TS"@"SEL$6" "F"@"SEL$6" "FE"@"SEL$6")
USE_NL(@"SEL$A731BD80" "HC"@"SEL$6")
USE_NL(@"SEL$A731BD80" "TS"@"SEL$6")
USE_NL(@"SEL$A731BD80" "F"@"SEL$6")
USE_NL(@"SEL$A731BD80" "FE"@"SEL$6")
FULL(@"SEL$C8360722" "X$KCCFN"@"SEL$5")
INDEX_RS_ASC(@"SEL$C8360722" "F"@"SEL$3" ("FILE$"."FILE#"))
FULL(@"SEL$C8360722" "FE"@"SEL$3")
INDEX(@"SEL$C8360722" "TS"@"SEL$3" "I_TS#")
LEADING(@"SEL$C8360722" "X$KCCFN"@"SEL$5" "F"@"SEL$3" "FE"@"SEL$3" "TS"@"SEL$3")
USE_NL(@"SEL$C8360722" "F"@"SEL$3")
USE_NL(@"SEL$C8360722" "FE"@"SEL$3")
USE_NL(@"SEL$C8360722" "TS"@"SEL$3")
FULL(@"SEL$29F99543" "V"@"SEL$16")
FULL(@"SEL$29F99543" "HC"@"SEL$16")
INDEX(@"SEL$29F99543" "TS"@"SEL$16" "I_TS#")
FULL(@"SEL$29F99543" "TF"@"SEL$16")
LEADING(@"SEL$29F99543" "V"@"SEL$16" "HC"@"SEL$16" "TS"@"SEL$16" "TF"@"SEL$16")
USE_NL(@"SEL$29F99543" "HC"@"SEL$16")
USE_NL(@"SEL$29F99543" "TS"@"SEL$16")
USE_NL(@"SEL$29F99543" "TF"@"SEL$16")
USE_HASH_AGGREGATION(@"SEL$29F99543")
INDEX_RS_ASC(@"SEL$ADB656C7" "TS"@"SEL$19" ("TS$"."NAME"))
FULL(@"SEL$ADB656C7" "HC"@"SEL$19")
LEADING(@"SEL$ADB656C7" "TS"@"SEL$19" "HC"@"SEL$19")
USE_NL(@"SEL$ADB656C7" "HC"@"SEL$19")
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
3 - access("D"."TABLESPACE_NAME"="F"."TABLESPACE_NAME")
11 - filter(("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE') AND
BITAND("FNFLG",4)<>4))
12 - filter("F"."SPARE1" IS NULL)
13 - access("FNFNO"="F"."FILE#")
14 - filter("FE"."FENUM"="F"."FILE#")
16 - access("F"."TS#"="TS"."TS#")
21 - filter(("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE') AND
BITAND("FNFLG",4)<>4))
22 - filter("FNFNO"="HC"."KTFBHCAFNO")
24 - access("HC"."KTFBHCTSN"="TS"."TS#")
25 - filter("F"."SPARE1" IS NOT NULL)
26 - access("FNFNO"="F"."FILE#")
27 - filter("FE"."FENUM"="F"."FILE#")
35 - filter("F"."FILE#"="FI"."RELFILE#")
36 - access("F"."TS#"="FI"."TS#")
37 - filter("TS"."BITMAPPED"=0)
38 - access("TS"."TS#"="F"."TS#")
41 - filter(("TS"."CONTENTS$"=0 AND "TS"."BITMAPPED"<>0 AND INTERNAL_FUNCTION("TS"."ONLINE$")))
42 - filter("TS"."TS#"="F"."KTFBFETSN")
43 - access("F"."KTFBFETSN"="FI"."TS#" AND "F"."KTFBFEFNO"="FI"."RELFILE#")
49 - access("RB"."TS#"="FI"."TS#")
50 - filter(("TS"."CONTENTS$"=0 AND "TS"."BITMAPPED"<>0 AND INTERNAL_FUNCTION("TS"."ONLINE$")))
51 - access("TS"."TS#"="RB"."TS#")
52 - filter(("U"."KTFBUEFNO"="FI"."RELFILE#" AND "U"."KTFBUESEGTSN"="RB"."TS#" AND
"U"."KTFBUESEGFNO"="RB"."FILE#" AND "U"."KTFBUESEGBNO"="RB"."BLOCK#"))
60 - access("U"."TS#"="RB"."TS#" AND "U"."SEGFILE#"="RB"."FILE#" AND
"U"."SEGBLOCK#"="RB"."BLOCK#")
filter(("U"."TS#"="FI"."TS#" A |