select s.a from t, s where t.a = s.a "APP"."T" "APP"."S" "APP"."T" 100.404 6 6.0 A 20.039500000000004 6 6.0 A "APP"."T_A" 20.039500000000004 6 6.0 "APP"."T" "APP"."S" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( "APP"."T_A" # "APP"."S_A" ) 40.179 3 0.6000000000000001 ( "APP"."T_A" # "APP"."S_A" ) 40.179 3 0.6000000000000001 "APP"."S" 100.404 6 6.0 A 20.039500000000004 6 6.0 A "APP"."S_A" 20.039500000000004 6 6.0 "APP"."S" "APP"."T" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( "APP"."S_A" # "APP"."T_A" ) 40.179 3 0.6000000000000001 select s.a from t, s, r where t.a = s.a and s.a = r.a "APP"."T" "APP"."S" "APP"."R" "APP"."T" 100.404 6 6.0 A 20.039500000000004 6 6.0 A "APP"."T_A" 20.039500000000004 6 6.0 "APP"."T" "APP"."S" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( "APP"."T_A" # "APP"."S_A" ) 40.179 3 0.6000000000000001 "APP"."T" "APP"."S" "APP"."R" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( ( "APP"."T_A" # "APP"."S_A" ) * "APP"."R_A" ) 52.484880000000004 2 0.6000000000000001 ( ( "APP"."T_A" # "APP"."S_A" ) * "APP"."R_A" ) 52.484880000000004 2 0.6000000000000001 "APP"."T" "APP"."R" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( "APP"."T_A" # "APP"."R_A" ) 40.179 3 0.6000000000000001 "APP"."T" "APP"."R" "APP"."S" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( ( "APP"."T_A" # "APP"."R_A" ) * "APP"."S_A" ) 52.484880000000004 2 0.6000000000000001 "APP"."S" 100.404 6 6.0 A 20.039500000000004 6 6.0 A "APP"."S_A" 20.039500000000004 6 6.0 "APP"."S" "APP"."T" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( "APP"."S_A" # "APP"."T_A" ) 40.179 3 0.6000000000000001 "APP"."S" "APP"."T" "APP"."R" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( ( "APP"."S_A" # "APP"."T_A" ) * "APP"."R_A" ) 52.484880000000004 2 0.6000000000000001 "APP"."S" "APP"."R" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( "APP"."S_A" # "APP"."R_A" ) 40.179 3 0.6000000000000001 "APP"."S" "APP"."R" "APP"."T" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( ( "APP"."S_A" # "APP"."R_A" ) * "APP"."T_A" ) 52.484880000000004 2 0.6000000000000001 "APP"."R" 100.404 6 6.0 A 20.039500000000004 6 6.0 A "APP"."R_A" 20.039500000000004 6 6.0 "APP"."R" "APP"."T" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( "APP"."R_A" # "APP"."T_A" ) 40.179 3 0.6000000000000001 "APP"."R" "APP"."T" "APP"."S" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( ( "APP"."R_A" # "APP"."T_A" ) * "APP"."S_A" ) 52.484880000000004 2 0.6000000000000001 "APP"."R" "APP"."S" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( "APP"."R_A" # "APP"."S_A" ) 40.179 3 0.6000000000000001 "APP"."R" "APP"."S" "APP"."T" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( ( "APP"."R_A" # "APP"."S_A" ) * "APP"."T_A" ) 52.484880000000004 2 0.6000000000000001 select s.a from s, table( integerList() ) i where s.a = i.a "APP"."S" "APP"."INTEGERLIST" "APP"."S" 100.404 6 6.0 A 20.039500000000004 6 6.0 A "APP"."S_A" 20.039500000000004 6 6.0 "APP"."S" "APP"."INTEGERLIST" ( "APP"."S_A" # "APP"."INTEGERLIST"() ) 100020.0395 10000 10000.0 ( "APP"."S_A" # "APP"."INTEGERLIST"() ) 100020.0395 10000 10000.0 "APP"."INTEGERLIST" "APP"."INTEGERLIST"() 100000.0 10000 10000.0 "APP"."INTEGERLIST" "APP"."S" 100.404 6 6.0 100.504 6 6.0 A 20.039500000000004 6 6.0 A 20.1395 6 6.0 ( "APP"."INTEGERLIST"() # "APP"."S_A" ) 100020.1395 6000 0.6000000000000001 call syscs_util.syscs_register_tool( 'optimizerTracing', false, 'z.xml' )