db2expln测试结果
DB2 Universal Database Version 8.1, 5622-044 (c) Copyright IBM Corp. 1991, 2002
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL Explain Tool
******************** DYNAMIC ***************************************
==================== STATEMENT ==========================================
Warning compiling statement:
SQL0347W 递归公共表表达式 "DB2ADMIN.T" 可能包含无限循环。 SQLSTATE=01605
Isolation Level = Cursor Stability
Blocking = Block Unambiguous Cursors
Query Optimization Class = 5
Partition Parallel = No
Intra-Partition Parallel = No
SQL Path = "SYSIBM", "SYSFUN", "SYSPROC", "XING"
SQL Statement:
select BUS_ORG_AUTO_CODE, JK_ID, KHDM, JKRXZH, JKRMCH, ZHJLX, ZHJHM,
LXFSH, LXDZH, XYSHMCH, WDMCH, BLZCHLX, BLXCHSHJ, LCHZHT,
CHZHFSH, JBR, DKYWH, JJH, HTJE, LL, JQJE, DBFSH, QX, DCHR,
DQR, SHDR, WJXT, JKYT, SHFZRDK, DYZRR, GLZRR, SHFTJ, DWFZR,
DKSHPR, SSDQSHJ, ZHCSHSHJ, BZH, JLZHT, SHJ, WCXZ, (
select YJHSHJE
from db2admin.APP_ZHQE a inner join db2admin.APP_JZHDCHXXQK b on
a.FK_JZHDCH_ID=b.JZHDCH_ID
where b.FK_JK_ID=c.jk_id )as YJHSHJE, (
select mch
from db2admin.dbrqk_i d
where d.fk_jk_id=c.jk_id)as 担保人, (
select ZCHZHL
from db2admin.REPORT_I_DZYW_UNIONALL e
where e.dkywh=c.dkywh)as 抵质押物, '1'as num
from db2admin.View_APP_JKQK c
where c.blzchlx in ('不良贷款', '已核销不良贷款', '票据置换不良贷款'
, '资产置换不良贷款', '政府收购')and ('001001'=
c.bus_org_auto_code or c.bus_org_auto_code like '001001')
and blzchlx <>'抵债资产'
Section Code Page = 1386
Estimated Cost = 127330.273438
Estimated Cardinality = 1964.521606
Access Table Name = DB2ADMIN.SYSBUSORG ID = 4,112
| Index Scan: Name = DB2ADMIN.PK_SYSBUSORG ID = 1
| | Regular Index (Not Clustered)
| | Index Columns:
| | | 1: BUS_ORG_ID (Ascending)
| #Columns = 2
| #Key Columns = 0
| | Start Key: Beginning of Index
| | Stop Key: End of Index
| Data Prefetch: Eligible 0
| Index Prefetch: None
| Lock Intents
| | Table: Intent Share
| | Row : Next Key Share
| Sargable Predicate(s)
| | #Predicates = 2
| | Process Build Table for Hash Join
Hash Join
| Estimated Build Size: 4418
| Estimated Probe Size: 34259020
| Bit Filter Size: 800
| Access Table Name = DB2ADMIN.APP_JKQK ID = 4,11
| | #Columns = 39
| | Relation Scan
| | | Prefetch: Eligible
| | Lock Intents
| | | Table: Intent Share
| | | Row : Next Key Share
| | Sargable Predicate(s)
| | | #Predicates = 2
| | | Process Probe Table for Hash Join
Nested Loop Join
| Piped Inner
| Data Stream 1:
| | Not Piped
| |
(
| | | Access Data Stream 1
| | | Access Temp Table ID = t1
| | | | #Columns = 4
| | | | Relation Scan
| | | | | Prefetch: Eligible
| | | Nested Loop Join
| | | | Data Stream 2:
| | | | | Not Piped
| | | | | Data Stream 3:
| | | | | | Not Piped
| | | | | | (
| | | | | | | Data Stream 4:
| | | | | | | | Not Piped
| | | | | | | | (
| | | | | | | | | Access Data Stream 4
| | | | | | | | | Access Temp Table ID = t2
| | | | | | | | | | #Columns = 4
| | | | | | | | | | Relation Scan
| | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | Nested Loop Join
| | | | | | | | | | Data Stream 5:
| | | | | | | | | | | Not Piped
| | | | | | | | | | | Data Stream 6:
| | | | | | | | | | | | Not Piped
| | | | | | | | | | | | Access Table Name = DB2ADMIN.APP_JXSHBDYW ID = 4,15
| | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | | Lock Intents
| | | | | | | | | | | | | | Table: Intent Share
| | | | | | | | | | | | | | Row : Next Key Share
| | | | | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | | | | Insert Into Sorted Temp Table ID = t3
| | | | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | | | #Sort Key Columns = 2
| | | | | | | | | | | | | | | | Key 1: DKYWH (Ascending)
| | | | | | | | | | | | | | | | Key 2: JQSHBDYW_ID (Ascending)
| | | | | | | | | | | | | | | Sortheap Allocation Parameters:
| | | | | | | | | | | | | | | | #Rows = 118
| | | | | | | | | | | | | | | | Row Width = 28
| | | | | | | | | | | | | | | Piped
| | | | | | | | | | | | Sorted Temp Table Completion ID = t3
| | | | | | | | | | | | Access Temp Table ID = t3
| | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | Insert Into Temp Table ID = t4
| | | | | | | | | | | | | #Columns = 4
| | | | | | | | | | | End of Data Stream 6
| | | | | | | | | | | Access Temp Table ID = t4
| | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | | | Insert Into Temp Table ID = t5
| | | | | | | | | | | | | | #Columns = 1
| | | | | | | | | |
| Temp Table Completion ID = t5
| | | | | | | | | | End of Data Stream 5
| | | | | | | | | | Access Temp Table ID = t5
| | | | | | | | | | | #Columns = 1
| | | | | | | | | | | Relation Scan
| | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | | #Predicates = 2
| | | | | | | | UNION
| | | | | | | | | Access Data Stream 6
| | | | | | | | | Access Temp Table ID = t4
| | | | | | | | | | #Columns = 2
| | | | | | | | | | Relation Scan
| | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | #Predicates = 2
| | | | | | | | )
| | | | | | | | Temp Table Completion ID = t2
| | | | | | | End of Data Stream 4
| | | | | | | Access Temp Table ID = t2
| | | | | | | | #Columns = 3
| | | | | | | | Relation Scan
| | | | | | | | | Prefetch: Eligible
| | | | | | | Nested Loop Join
| | | | | | | | Piped Inner
| | | | | | | | Access Data Stream 6
| | | | | | | | Access Temp Table ID = t4
| | | | | | | | | #Columns = 1
| | | | | | | | | Relation Scan
| | | | | | | | | | Prefetch: 1 Pages
| | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | #Predicates = 1
| | | | | | | | | | Predicate Aggregation
| | | | | | | | | | | Column Function(s)
| | | | | | | | Aggregation Completion
| | | | | | | | | Column Function(s)
| | | | | | | | Residual Predicate(s)
| | | | | | | | | #Predicates = 1
| | | | | | UNION
| | | | | | | Data Stream 7:
| | | | | | | | Not Piped
| | | | | | | | (
| | | | | | | | | Access Data Stream 7
| | | | | | | | | Access Temp Table ID = t6
| | | | | | | | | | #Columns = 4
| | | | | | | | | | Relation Scan
| | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | Nested Loop Join
| | | | | | | | | | Data Stream 8:
| | | | | | | | | | | Not Piped
| | | | | | | | | | | Data Stream 9:
| | | | | | | | | | | | Not Piped
| | | | | | | | | | | | Access Table Name = DB2ADMIN.APP_TDDYWXX ID = 4,22
| | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | | Lock Intents
| | | | | | | | | | | | | | Table: Intent Share
| | | | | | | | | | | | | | Row : Next Key Share
| | | | | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | | | | Insert Into Sor
ted Temp Table ID = t7
| | | | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | | | #Sort Key Columns = 2
| | | | | | | | | | | | | | | | Key 1: DKYWH (Ascending)
| | | | | | | | | | | | | | | | Key 2: TDDYW_ID (Ascending)
| | | | | | | | | | | | | | | Sortheap Allocation Parameters:
| | | | | | | | | | | | | | | | #Rows = 59
| | | | | | | | | | | | | | | | Row Width = 24
| | | | | | | | | | | | | | | Piped
| | | | | | | | | | | | Sorted Temp Table Completion ID = t7
| | | | | | | | | | | | Access Temp Table ID = t7
| | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | Insert Into Temp Table ID = t8
| | | | | | | | | | | | | #Columns = 4
| | | | | | | | | | | End of Data Stream 9
| | | | | | | | | | | Access Temp Table ID = t8
| | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | | | Insert Into Temp Table ID = t9
| | | | | | | | | | | | | | #Columns = 1
| | | | | | | | | | | Temp Table Completion ID = t9
| | | | | | | | | | End of Data Stream 8
| | | | | | | | | | Access Temp Table ID = t9
| | | | | | | | | | | #Columns = 1
| | | | | | | | | | | Relation Scan
| | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | | #Predicates = 2
| | | | | | | | UNION
| | | | | | | | | Access Data Stream 9
| | | | | | | | | Access Temp Table ID = t8
| | | | | | | | | | #Columns = 2
| | | | | | | | | | Relation Scan
| | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | #Predicates = 2
| | | | | | | | )
| | | | | | | | Temp Table Completion ID = t6
| | | | | | | End of Data Stream 7
| | | | | | | Access Temp Table ID = t6
| | | | | | | | #Columns = 3
| | | | | | | | Relation Scan
| | | | | | | | | Prefetch: Eligible
| | | | | | | Nested Loop Join
| | | | | | | | Piped Inner
| | | | | | | | Access Data Stream 9
| | | | | | | | Access Temp Table ID = t8
| | | | | | | | | #Columns = 1
| | | | | | | | | Relation Scan
| | | | | | | | | | Prefetch: 1 Pages
| | | | | | | | | Sargable Predicate(s)
| | | | | | |
| | | #Predicates = 1
| | | | | | | | | | Predicate Aggregation
| | | | | | | | | | | Column Function(s)
| | | | | | | | Aggregation Completion
| | | | | | | | | Column Function(s)
| | | | | | | | Residual Predicate(s)
| | | | | | | | | #Predicates = 1
| | | | | | UNION
| | | | | | | Data Stream 10:
| | | | | | | | Not Piped
| | | | | | | | (
| | | | | | | | | Access Data Stream 10
| | | | | | | | | Access Temp Table ID = t10
| | | | | | | | | | #Columns = 4
| | | | | | | | | | Relation Scan
| | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | Nested Loop Join
| | | | | | | | | | Data Stream 11:
| | | | | | | | | | | Not Piped
| | | | | | | | | | | Data Stream 12:
| | | | | | | | | | | | Not Piped
| | | | | | | | | | | | Access Table Name = DB2ADMIN.APP_FCHDYWXX ID = 4,9
| | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | | Lock Intents
| | | | | | | | | | | | | | Table: Intent Share
| | | | | | | | | | | | | | Row : Next Key Share
| | | | | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | | | | Insert Into Sorted Temp Table ID = t11
| | | | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | | | #Sort Key Columns = 2
| | | | | | | | | | | | | | | | Key 1: DKYWH (Ascending)
| | | | | | | | | | | | | | | | Key 2: FWDYW_ID (Ascending)
| | | | | | | | | | | | | | | Sortheap Allocation Parameters:
| | | | | | | | | | | | | | | | #Rows = 193
| | | | | | | | | | | | | | | | Row Width = 24
| | | | | | | | | | | | | | | Piped
| | | | | | | | | | | | Sorted Temp Table Completion ID = t11
| | | | | | | | | | | | Access Temp Table ID = t11
| | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | Insert Into Temp Table ID = t12
| | | | | | | | | | | | | #Columns = 4
| | | | | | | | | | | End of Data Stream 12
| | | | | | | | | | | Access Temp Table ID = t12
| | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | | | Insert Into Temp Table ID = t13
| | | | | | | | | | | | | | #Columns = 1
|
| | | | | | | | | | Temp Table Completion ID = t13
| | | | | | | | | | End of Data Stream 11
| | | | | | | | | | Access Temp Table ID = t13
| | | | | | | | | | | #Columns = 1
| | | | | | | | | | | Relation Scan
| | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | | #Predicates = 2
| | | | | | | | UNION
| | | | | | | | | Access Data Stream 12
| | | | | | | | | Access Temp Table ID = t12
| | | | | | | | | | #Columns = 2
| | | | | | | | | | Relation Scan
| | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | #Predicates = 2
| | | | | | | | )
| | | | | | | | Temp Table Completion ID = t10
| | | | | | | End of Data Stream 10
| | | | | | | Access Temp Table ID = t10
| | | | | | | | #Columns = 3
| | | | | | | | Relation Scan
| | | | | | | | | Prefetch: Eligible
| | | | | | | Nested Loop Join
| | | | | | | | Piped Inner
| | | | | | | | Access Data Stream 12
| | | | | | | | Access Temp Table ID = t12
| | | | | | | | | #Columns = 1
| | | | | | | | | Relation Scan
| | | | | | | | | | Prefetch: 1 Pages
| | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | #Predicates = 1
| | | | | | | | | | Predicate Aggregation
| | | | | | | | | | | Column Function(s)
| | | | | | | | Aggregation Completion
| | | | | | | | | Column Function(s)
| | | | | | | | Residual Predicate(s)
| | | | | | | | | #Predicates = 1
| | | | | | UNION
| | | | | | | Data Stream 13:
| | | | | | | | Not Piped
| | | | | | | | (
| | | | | | | | | Access Data Stream 13
| | | | | | | | | Access Temp Table ID = t14
| | | | | | | | | | #Columns = 4
| | | | | | | | | | Relation Scan
| | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | Nested Loop Join
| | | | | | | | | | Data Stream 14:
| | | | | | | | | | | Not Piped
| | | | | | | | | | | Data Stream 15:
| | | | | | | | | | | | Not Piped
| | | | | | | | | | | | Access Table Name = DB2ADMIN.APP_ZHYW ID = 4,26
| | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | | Lock Intents
| | | | | | | | | | | | | | Table: Intent Share
| | | | | | | | | | | | | | Row : Next Key Share
| | | | | | | | | | | | | Sargable Predicate(s)
| | | | | | |
| | | | | | | Insert Into Sorted Temp Table ID = t15
| | | | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | | | #Sort Key Columns = 2
| | | | | | | | | | | | | | | | Key 1: DKYWH (Ascending)
| | | | | | | | | | | | | | | | Key 2: ZHYW_ID (Ascending)
| | | | | | | | | | | | | | | Sortheap Allocation Parameters:
| | | | | | | | | | | | | | | | #Rows = 21
| | | | | | | | | | | | | | | | Row Width = 24
| | | | | | | | | | | | | | | Piped
| | | | | | | | | | | | Sorted Temp Table Completion ID = t15
| | | | | | | | | | | | Access Temp Table ID = t15
| | | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | Insert Into Temp Table ID = t16
| | | | | | | | | | | | | #Columns = 4
| | | | | | | | | | | End of Data Stream 15
| | | | | | | | | | | Access Temp Table ID = t16
| | | | | | | | | | | | #Columns = 3
| | | | | | | | | | | | Relation Scan
| | | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | | | Insert Into Temp Table ID = t17
| | | | | | | | | | | | | | #Columns = 1
| | | | | | | | | | | Temp Table Completion ID = t17
| | | | | | | | | | End of Data Stream 14
| | | | | | | | | | Access Temp Table ID = t17
| | | | | | | | | | | #Columns = 1
| | | | | | | | | | | Relation Scan
| | | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | | #Predicates = 2
| | | | | | | | UNION
| | | | | | | | | Access Data Stream 15
| | | | | | | | | Access Temp Table ID = t16
| | | | | | | | | | #Columns = 2
| | | | | | | | | | Relation Scan
| | | | | | | | | | | Prefetch: Eligible
| | | | | | | | | | Sargable Predicate(s)
| | | | | | | | | | | #Predicates = 2
| | | | | | | | )
| | | | | | | | Temp Table Completion ID = t14
| | | | | | | End of Data Stream 13
| | | | | | | Access Temp Table ID = t14
| | | | | | | | #Columns = 3
| | | | | | | | Relation Scan
| | | | | | | | | Prefetch: Eligible
| | | | | | | Nested Loop Join
| | | | | | | | Piped Inner
| | | | | | | | Access Data Stream 15
| | | | | | | | Access Temp Table ID = t16
| | | | | | | | | #Columns = 1
| | | | | | | | | Relation Scan
| | | | | | | | | | Prefetch: 1 Pages
| | | | | | |
| | Sargable Predicate(s)
| | | | | | | | | | #Predicates = 1
| | | | | | | | | | Predicate Aggregation
| | | | | | | | | | | Column Function(s)
| | | | | | | | Aggregation Completion
| | | | | | | | | Column Function(s)
| | | | | | | | Residual Predicate(s)
| | | | | | | | | #Predicates = 1
| | | | | | )
| | | | | | Insert Into Sorted Temp Table ID = t18
| | | | | | | #Columns = 2
| | | | | | | #Sort Key Columns = 2
| | | | | | | | Key 1: (Ascending)
| | | | | | | | Key 2: (Ascending)
| | | | | | | Sortheap Allocation Parameters:
| | | | | | | | #Rows = 26
| | | | | | | | Row Width = 92
| | | | | | | Piped
| | | | | | | Duplicate Elimination
| | | | | | Access Temp Table ID = t18
| | | | | | | #Columns = 2
| | | | | | | Relation Scan
| | | | | | | | Prefetch: Eligible
| | | | | | Insert Into Temp Table ID = t19
| | | | | | | #Columns = 4
| | | | | End of Data Stream 3
| | | | | Access Temp Table ID = t19
| | | | | | #Columns = 3
| | | | | | Relation Scan
| | | | | | | Prefetch: Eligible
| | | | | | Sargable Predicate(s)
| | | | | | | Insert Into Temp Table ID = t20
| | | | | | | | #Columns = 1
| | | | | Temp Table Completion ID = t20
| | | | End of Data Stream 2
| | | | Access Temp Table ID = t20
| | | | | #Columns = 1
| | | | | Relation Scan
| | | | | | Prefetch: Eligible
| | | | | Sargable Predicate(s)
| | | | | | #Predicates = 2
| | UNION
| | | Access Data Stream 3
| | | Access Temp Table ID = t19
| | | | #Columns = 2
| | | | Relation Scan
| | | | | Prefetch: Eligible
| | | | Sargable Predicate(s)
| | | | | #Predicates = 2
| | )
| | Temp Table Completion ID = t1
| End of Data Stream 1
| Access Temp Table ID = t1
| | #Columns = 3
| | Relation Scan
| | | Prefetch: Eligible
| | Sargable Predicate(s)
| | | #Predicates = 1
| Nested Loop Join
| | Piped Inner
| | Access Data Stream 3
| | Access Temp Table ID = t19
| | | #Columns = 1
| | | Relation Scan
| | | | Prefetch: 1 Pages
| | | Sargable Predicate(s)
| | | | #Predicates = 1
| | | | Predicate Aggregation
| | | | | Column Function(s)
| | Aggregation Completion
| | | Column Function(s)
| | Residual Predicate(s)
| | | #Predicates = 1
Nested Loop Join
| Piped Inner
| Access Table Name = DB2ADMIN.APP_JZHDCHXXQK ID = 4,20
| | Index Scan: Name = DB2ADMIN.IX_APP_JZHDCHXXQK ID = 2
| | | Regular Index (Not Clustered)
| | | Index Columns:
| | | | 1: FK_JK_ID (Ascending)
| | #Columns = 1
| | Single Record
| | Fully Qualified Unique Key
| | #K
ey Columns = 1
| | | Start Key: Inclusive Value
| | | | | 1: ?
| | | Stop Key: Inclusive Value
| | | | | 1: ?
| | Data Prefetch: None
| | Index Prefetch: None
| | Lock Intents
| | | Table: Intent Share
| | | Row : Next Key Share
| Nested Loop Join
| | Access Table Name = DB2ADMIN.APP_ZHQE ID = 4,23
| | | #Columns = 1
| | | Relation Scan
| | | | Prefetch: Eligible
| | | Lock Intents
| | | | Table: Intent Share
| | | | Row : Next Key Share
| | | Sargable Predicate(s)
| | | | #Predicates = 1
Nested Loop Join
| Piped Inner
| Data Stream 16:
| | Not Piped
| | (
| | | Access Data Stream 16
| | | Access Temp Table ID = t21
| | | | #Columns = 4
| | | | Relation Scan
| | | | | Prefetch: Eligible
| | | Nested Loop Join
| | | | Data Stream 17:
| | | | | Not Piped
| | | | | Data Stream 18:
| | | | | | Not Piped
| | | | | | Access Table Name = DB2ADMIN.APP_DBRQK ID = 4,6
| | | | | | | #Columns = 3
| | | | | | | Relation Scan
| | | | | | | | Prefetch: Eligible
| | | | | | | Lock Intents
| | | | | | | | Table: Intent Share
| | | | | | | | Row : Next Key Share
| | | | | | | Sargable Predicate(s)
| | | | | | | | Insert Into Sorted Temp Table ID = t22
| | | | | | | | | #Columns = 3
| | | | | | | | | #Sort Key Columns = 2
| | | | | | | | | | Key 1: FK_JK_ID (Ascending)
| | | | | | | | | | Key 2: DBR_ID (Ascending)
| | | | | | | | | Sortheap Allocation Parameters:
| | | | | | | | | | #Rows = 78662
| | | | | | | | | | Row Width = 24
| | | | | | | | | Piped
| | | | | | Sorted Temp Table Completion ID = t22
| | | | | | Access Temp Table ID = t22
| | | | | | | #Columns = 3
| | | | | | | Relation Scan
| | | | | | | | Prefetch: Eligible
| | | | | | Insert Into Temp Table ID = t23
| | | | | | | #Columns = 4
| | | | | End of Data Stream 18
| | | | | Access Temp Table ID = t23
| | | | | | #Columns = 3
| | | | | | Relation Scan
| | | | | | | Prefetch: Eligible
| | | | | | Sargable Predicate(s)
| | | | | | | Insert Into Temp Table ID = t24
| | | | | | | | #Columns = 1
| | | | | Temp Table Completion ID = t24
| | | | End of Data Stream 17
| | | | Access Temp Table ID = t24
| | | | | #Columns = 1
| | | | | Relation Scan
| | | | | | Prefetch: Eligible
| | | | | Sargable Predicate(s)
| | | | | | #Predicates = 2
| | UNION
| | | Access Data Stream 18
| | | Access Temp Table ID = t23
| | | | #Columns = 2
| | | | Relation Scan
| | | | | Prefetch: Eligible
| | | | Sargable Predicate(s)
| | | | | #P
redicates = 2
| | )
| | Temp Table Completion ID = t21
| End of Data Stream 16
| Access Temp Table ID = t21
| | #Columns = 3
| | Relation Scan
| | | Prefetch: Eligible
| | Sargable Predicate(s)
| | | #Predicates = 1
| Nested Loop Join
| | Piped Inner
| | Access Data Stream 18
| | Access Temp Table ID = t23
| | | #Columns = 1
| | | Relation Scan
| | | | Prefetch: 1236 Pages
| | | Sargable Predicate(s)
| | | | #Predicates = 1
| | | | Predicate Aggregation
| | | | | Column Function(s)
| | Aggregation Completion
| | | Column Function(s)
| | Residual Predicate(s)
| | | #Predicates = 1
Return Data to Application
| #Columns = 44
End of section