predicatepushdown.out

derby database source code.good for you.

	Source result set:
		Sort ResultSet:
		Number of opens = 1
		Rows input = 43
		Rows returned = 21
		Eliminate duplicates = true
		In sorted order = false
		Sort information: 
			Number of rows input=43
			Number of rows output=21
			constructor time (milliseconds) = 0
			open time (milliseconds) = 0
			next time (milliseconds) = 0
			close time (milliseconds) = 0
		Source result set:
			Union ResultSet:
			Number of opens = 1
			Rows seen from the left = 31
			Rows seen from the right = 12
			Rows returned = 43
				constructor time (milliseconds) = 0
				open time (milliseconds) = 0
				next time (milliseconds) = 0
				close time (milliseconds) = 0
			Left result set:
				Union ResultSet:
				Number of opens = 1
				Rows seen from the left = 19
				Rows seen from the right = 12
				Rows returned = 31
					constructor time (milliseconds) = 0
					open time (milliseconds) = 0
					next time (milliseconds) = 0
					close time (milliseconds) = 0
				Left result set:
					Table Scan ResultSet for T3 at read committed isolation level using share row locking chosen by the optimizer
					Number of opens = 1
					Rows seen = 19
					Rows filtered = 0
					Fetch Size = 1
						constructor time (milliseconds) = 0
						open time (milliseconds) = 0
						next time (milliseconds) = 0
						close time (milliseconds) = 0
						next time in milliseconds/row = 0
					scan information: 
						Bit set of columns fetched=All
						Number of columns fetched=2
						Number of pages visited=1
						Number of rows qualified=19
						Number of rows visited=19
						Scan type=heap
						start position: 
null						stop position: 
null						qualifiers:
None
				Right result set:
					Table Scan ResultSet for T4 at read committed isolation level using share row locking chosen by the optimizer
					Number of opens = 1
					Rows seen = 12
					Rows filtered = 0
					Fetch Size = 1
						constructor time (milliseconds) = 0
						open time (milliseconds) = 0
						next time (milliseconds) = 0
						close time (milliseconds) = 0
						next time in milliseconds/row = 0
					scan information: 
						Bit set of columns fetched=All
						Number of columns fetched=2
						Number of pages visited=1
						Number of rows qualified=12
						Number of rows visited=12
						Scan type=heap
						start position: 
null						stop position: 
null						qualifiers:
None
			Right result set:
				Table Scan ResultSet for T4 at read committed isolation level using share row locking chosen by the optimizer
				Number of opens = 1
				Rows seen = 12
				Rows filtered = 0
				Fetch Size = 1
					constructor time (milliseconds) = 0
					open time (milliseconds) = 0
					next time (milliseconds) = 0
					close time (milliseconds) = 0
					next time in milliseconds/row = 0
				scan information: 
					Bit set of columns fetched=All
					Number of columns fetched=2
					Number of pages visited=1
					Number of rows qualified=12
					Number of rows visited=12
					Scan type=heap
					start position: 
null					stop position: 
null					qualifiers:
None
ij> -- UNION ALLs.
select * from
  (select * from t1 union all select * from t2) x1,
  (select * from t3 union select * from t4) x2
where x1.i = x2.a;
I          |J          |A          |B          
-----------------------------------------------
1          |2          |1          |1          
2          |4          |2          |2          
3          |6          |3          |3          
3          |6          |3          |12         
4          |8          |4          |4          
4          |8          |4          |16         
1          |2          |1          |1          
2          |-4         |2          |2          
3          |6          |3          |3          
3          |6          |3          |12         
4          |-8         |4          |4          
4          |-8         |4          |16         
ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Statement Name: 
	null
Statement Text: 
	-- UNION ALLs.
select * from
  (select * from t1 union all select * from t2) x1,
  (select * from t3 union select * from t4) x2
where x1.i = x2.a
Parse Time: 0
Bind Time: 0
Optimize Time: 0
Generate Time: 0
Compile Time: 0
Execute Time: 0
Begin Compilation Timestamp : null
End Compilation Timestamp : null
Begin Execution Timestamp : null
End Execution Timestamp : null
Statement Execution Plan Text: 
Hash Join ResultSet:
Number of opens = 1
Rows seen from the left = 10
Rows seen from the right = 12
Rows filtered = 0
Rows returned = 12
	constructor time (milliseconds) = 0
	open time (milliseconds) = 0
	next time (milliseconds) = 0
	close time (milliseconds) = 0
Left result set:
	Union ResultSet:
	Number of opens = 1
	Rows seen from the left = 5
	Rows seen from the right = 5
	Rows returned = 10
		constructor time (milliseconds) = 0
		open time (milliseconds) = 0
		next time (milliseconds) = 0
		close time (milliseconds) = 0
	Left result set:
		Table Scan ResultSet for T1 at read committed isolation level using share row locking chosen by the optimizer
		Number of opens = 1
		Rows seen = 5
		Rows filtered = 0
		Fetch Size = 1
			constructor time (milliseconds) = 0
			open time (milliseconds) = 0
			next time (milliseconds) = 0
			close time (milliseconds) = 0
			next time in milliseconds/row = 0
		scan information: 
			Bit set of columns fetched=All
			Number of columns fetched=2
			Number of pages visited=1
			Number of rows qualified=5
			Number of rows visited=5
			Scan type=heap
			start position: 
null			stop position: 
null			qualifiers:
None
	Right result set:
		Table Scan ResultSet for T2 at read committed isolation level using share row locking chosen by the optimizer
		Number of opens = 1
		Rows seen = 5
		Rows filtered = 0
		Fetch Size = 1
			constructor time (milliseconds) = 0
			open time (milliseconds) = 0
			next time (milliseconds) = 0
			close time (milliseconds) = 0
			next time in milliseconds/row = 0
		scan information: 
			Bit set of columns fetched=All
			Number of columns fetched=2
			Number of pages visited=1
			Number of rows qualified=5
			Number of rows visited=5
			Scan type=heap
			start position: 
null			stop position: 
null			qualifiers:
None
Right result set:
	Hash Table ResultSet (9):
	Number of opens = 10
	Hash table size = 19
	Hash key is column number 0
	Rows seen = 21
	Rows filtered = 0
		constructor time (milliseconds) = 0
		open time (milliseconds) = 0
		next time (milliseconds) = 0
		close time (milliseconds) = 0
		next time in milliseconds/row = 0
		next qualifiers:
Column[0][0] Id: 0
Operator: =
Ordered nulls: false
Unknown return value: false
Negate comparison result: false
	Source result set:
		Sort ResultSet:
		Number of opens = 1
		Rows input = 31
		Rows returned = 21
		Eliminate duplicates = true
		In sorted order = false
		Sort information: 
			Number of rows input=31
			Number of rows output=21
			constructor time (milliseconds) = 0
			open time (milliseconds) = 0
			next time (milliseconds) = 0
			close time (milliseconds) = 0
		Source result set:
			Union ResultSet:
			Number of opens = 1
			Rows seen from the left = 19
			Rows seen from the right = 12
			Rows returned = 31
				constructor time (milliseconds) = 0
				open time (milliseconds) = 0
				next time (milliseconds) = 0
				close time (milliseconds) = 0
			Left result set:
				Table Scan ResultSet for T3 at read committed isolation level using share row locking chosen by the optimizer
				Number of opens = 1
				Rows seen = 19
				Rows filtered = 0
				Fetch Size = 1
					constructor time (milliseconds) = 0
					open time (milliseconds) = 0
					next time (milliseconds) = 0
					close time (milliseconds) = 0
					next time in milliseconds/row = 0
				scan information: 
					Bit set of columns fetched=All
					Number of columns fetched=2
					Number of pages visited=1
					Number of rows qualified=19
					Number of rows visited=19
					Scan type=heap
					start position: 
null					stop position: 
null					qualifiers:
None
			Right result set:
				Table Scan ResultSet for T4 at read committed isolation level using share row locking chosen by the optimizer
				Number of opens = 1
				Rows seen = 12
				Rows filtered = 0
				Fetch Size = 1
					constructor time (milliseconds) = 0
					open time (milliseconds) = 0
					next time (milliseconds) = 0
					close time (milliseconds) = 0
					next time in milliseconds/row = 0
				scan information: 
					Bit set of columns fetched=All
					Number of columns fetched=2
					Number of pages visited=1
					Number of rows qualified=12
					Number of rows visited=12
					Scan type=heap
					start position: 
null					stop position: 
null					qualifiers:
None
ij> select * from
  (select * from t1 union select * from t2) x1,
  (select * from t3 union all select * from t4) x2
where x1.i = x2.a;
I          |J          |A          |B          
-----------------------------------------------
1          |2          |1          |1          
2          |-4         |2          |2          
2          |4          |2          |2          
3          |6          |3          |3          
3          |6          |3          |12         
4          |-8         |4          |4          
4          |-8         |4          |16         
4          |8          |4          |4          
4          |8          |4          |16         
ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Statement Name: 
	null
Statement Text: 
	select * from
  (select * from t1 union select * from t2) x1,
  (select * from t3 union all select * from t4) x2
where x1.i = x2.a
Parse Time: 0
Bind Time: 0
Optimize Time: 0
Generate Time: 0
Compile Time: 0
Execute Time: 0
Begin Compilation Timestamp : null
End Compilation Timestamp : null
Begin Execution Timestamp : null