******* Attached subqueries:
	Begin Subquery Number 0
	Any ResultSet  (Attached to 2):
	Number of opens = 7508
	Rows seen = 7508
		constructor time (milliseconds) = 0
		open time (milliseconds) = 0
		next time (milliseconds) = 0
		close time (milliseconds) = 0
		optimizer estimated row count:    333734973.00
		optimizer estimated cost:    205150563.85

	Source result set:
		Project-Restrict ResultSet (7):
		Number of opens = 7508
		Rows seen = 833388
		Rows filtered = 833388
		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:    333734973.00
			optimizer estimated cost:    205150563.85

		Source result set:
			Project-Restrict ResultSet (6):
			Number of opens = 7508
			Rows seen = 833388
			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:    333734973.00
				optimizer estimated cost:    205150563.85

			Source result set:
				Hash Exists Join ResultSet:
				Number of opens = 7508
				Rows seen from the left = 333475328
				Rows seen from the right = 833388
				Rows filtered = 0
				Rows returned = 833388
					constructor time (milliseconds) = 0
					open time (milliseconds) = 0
					next time (milliseconds) = 0
					close time (milliseconds) = 0
					optimizer estimated row count:    333734973.00
					optimizer estimated cost:    205150563.85

				Left result set:
					Table Scan ResultSet for STREET_REFERENCE at read committed isolation level using share row locking chosen by the optimizer
					Number of opens = 7508
					Rows seen = 333475328
					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, 7}
						Number of columns fetched=2
						Number of pages visited=1246
						Number of rows qualified=333475328
						Number of rows visited=338986200
						Scan type=heap
						start position:
							null
						stop position:
							null
						qualifiers:
							None
						optimizer estimated row count:    333734973.00
						optimizer estimated cost:    205149797.69

				Right result set:
					Hash Scan ResultSet for TOWNSHIP_REFERENCE at read committed isolation level using instantaneous share row locking: 
					Number of opens = 333475328
					Hash table size = 55
					Hash key is column number 0
					Rows seen = 833388
					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={0, 6}
						Number of columns fetched=2
						Number of pages visited=33
						Number of rows qualified=55
						Number of rows visited=1284
						Scan type=heap
						start position:
							null
						stop position:
							null
						scan qualifiers:
							Column[0][0] Id: 6
							Operator: =
							Ordered nulls: false
							Unknown return value: false
							Negate comparison result: false
						next qualifiers:
							Column[0][0] Id: 0
							Operator: =
							Ordered nulls: false
							Unknown return value: false
							Negate comparison result: false
						optimizer estimated row count:    333734973.00
						optimizer estimated cost:          766.16


	End Subquery Number 0
Project-Restrict ResultSet (2):
Number of opens = 1
Rows seen = 7508
Rows filtered = 7508
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:         7513.00
	optimizer estimated cost:         4681.53

Source result set:
	Table Scan ResultSet for HOUSE_REFERENCE at read committed isolation level using instantaneous share row locking chosen by the optimizer
	Number of opens = 1
	Rows seen = 7508
	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=5
		Number of pages visited=213
		Number of rows qualified=7508
		Number of rows visited=7508
		Scan type=heap
		start position:
			null
		stop position:
			null
		qualifiers:
			None
		optimizer estimated row count:         7513.00
		optimizer estimated cost:         4681.53