******* 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