2008-01-17 19:00:54.922 GMT Thread[main,5,main] (XID = 166), (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 (6):
Number of opens = 1
Rows seen = 2
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:            1.00
	optimizer estimated cost:           24.90

Source result set:
	Project-Restrict ResultSet (5):
	Number of opens = 1
	Rows seen = 2
	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:            1.00
		optimizer estimated cost:           24.90

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

		Source result set:
			Project-Restrict ResultSet (4):
			Number of opens = 1
			Rows seen = 6
			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:            6.48
				optimizer estimated cost:           24.90

			Source result set:
				Project-Restrict ResultSet (3):
				Number of opens = 1
				Rows seen = 20
				Rows filtered = 14
				restriction = true
				projection = false
					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:            6.48
					optimizer estimated cost:           24.90

				Source result set:
					Table Scan ResultSet for TEST_TABLE at read committed isolation level using share row locking chosen by the optimizer
					Number of opens = 1
					Rows seen = 20
					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={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:
Column[0][0] Id: 3
Operator: =
Ordered nulls: true
Unknown return value: true
Negate comparison result: true

						optimizer estimated row count:            6.48
						optimizer estimated cost:           24.90