2008-01-17 18:29:38.281 GMT Thread[main,5,main] (XID = 251), (SESSIONID = 0), SELECT COUNT(t0.ID) FROM CTS1.TEST_TABLE t0 GROUP BY t0.CODE HAVING (t0.CODE = ? OR t0.CODE = ?) AND t0.CODE IS NOT NULL ******* Project-Restrict ResultSet (4):
Number of opens = 1
Rows seen = 5
Rows filtered = 4
restriction = true
projection = true
	constructor time (milliseconds) = 0
	open time (milliseconds) = 0
	next time (milliseconds) = 0
	close time (milliseconds) = 0
	restriction time (milliseconds) = 0
	projection time (milliseconds) = 0
	optimizer estimated row count:            1.00
	optimizer estimated cost:           24.90

Source result set:
	Grouped Aggregate ResultSet:
	Number of opens = 1
	Rows input = 20
	Has distinct aggregate = false
	In sorted order = false
	Sort information: 
		Number of rows input=20
		Number of rows output=5
		Sort type=internal
		constructor time (milliseconds) = 0
		open time (milliseconds) = 0
		next time (milliseconds) = 0
		close time (milliseconds) = 0
		optimizer estimated row count:           24.00
		optimizer estimated cost:           24.90

	Source result set:
		Project-Restrict ResultSet (3):
		Number of opens = 1
		Rows seen = 20
		Rows filtered = 0
		restriction = false
		projection = true
			constructor time (milliseconds) = 0
			open time (milliseconds) = 0
			next time (milliseconds) = 0
			close time (milliseconds) = 0
			restriction time (milliseconds) = 0
			projection time (milliseconds) = 0
			optimizer estimated row count:           24.00
			optimizer estimated cost:           24.90

		Source result set:
			Table Scan ResultSet for TEST_TABLE at read committed isolation level using instantaneous share row locking chosen by the optimizer
			Number of opens = 1
			Rows seen = 20
			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={0, 3}
				Number of columns fetched=2
				Number of pages visited=1
				Number of rows qualified=20
				Number of rows visited=20
				Scan type=heap
				start position: 
null				stop position: 
null				qualifiers:
None
				optimizer estimated row count:           24.00
				optimizer estimated cost:           24.90