Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ******* 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement