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' )