maxmempertab.out

来自「derby database source code.good for you.」· OUT 代码 · 共 188 行 · 第 1/3 页

Rows seen from the left = 3
Rows seen from the right = 2
Rows filtered = 0
Rows returned = 2
	constructor time (milliseconds) = 0
	open time (milliseconds) = 0
	next time (milliseconds) = 0
	close time (milliseconds) = 0
Left result set:
	Table Scan ResultSet for TAB3 at read committed isolation level using instantaneous share row locking chosen by the optimizer
	Number of opens = 1
	Rows seen = 3
	Rows filtered = 0
	Fetch Size = 16
		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=3
		Number of rows qualified=3
		Number of rows visited=3
		Scan type=heap
		start position: 
null		stop position: 
null		qualifiers:
None
Right result set:
	Hash Scan ResultSet for TAB4 at read committed isolation level using instantaneous share row locking: 
	Number of opens = 3
	Hash table size = 3
	Hash key is column number 1
	Rows seen = 2
	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
	scan information: 
		Bit set of columns fetched=All
		Number of columns fetched=2
		Number of pages visited=3
		Number of rows qualified=3
		Number of rows visited=3
		Scan type=heap
		start position: 
null		stop position: 
null		scan qualifiers:
None
		next qualifiers:
Column[0][0] Id: 1
Operator: =
Ordered nulls: false
Unknown return value: false
Negate comparison result: false
ij> rollback;
ij>