1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184
|
QUERY PLAN FOR STATEMENT 1 (at line 1).
Executed in parallel by coordinating process and 3 worker processes.
STEP 1
The type of query is INSERT.
The update mode is direct.
Executed by coordinating process.
Worktable2 created for REFORMATTING.
FROM TABLE
panorama..PartitionMapData
PMD
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 16 Kbytes for data pages.
With MRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable2.
STEP 2
The type of query is INSERT.
The update mode is direct.
Executed in parallel by coordinating process and 3 worker processes.
Worktable3 created for REFORMATTING.
FROM TABLE
panorama..ValuationTabResults
VTR
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Executed in parallel with a 3-way hash scan.
Using I/O Size 16 Kbytes for data pages.
With MRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable3.
STEP 3
The type of query is SELECT (into Worktable1).
GROUP BY
Evaluate Grouped SUM OR AVERAGE AGGREGATE.
Executed in parallel by coordinating process and 3 worker processes.
FROM TABLE
interfaces..RPTRISK_DeskPortfolioMapping
dpm
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
panorama..InstrumentLeg
LG
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Executed in parallel with a 3-way hash scan.
Using I/O Size 16 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
panorama..Instrument
INS
Nested iteration.
Using Clustered Index.
Index : PK_Instrument_1__137
Forward scan.
Positioning by key.
Keys are:
InstrumentID ASC
VersionNumber ASC
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
Worktable2.
Nested iteration.
Using Clustered Index.
Forward scan.
Positioning by key.
Using I/O Size 16 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
Worktable3.
Nested iteration.
Using Clustered Index.
Forward scan.
Positioning by key.
Using I/O Size 16 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
panorama..PortfolioResults
p
Nested iteration.
Index : PK_PortfolioResults
Forward scan.
Positioning by key.
Keys are:
ResultsID ASC
Using I/O Size 2 Kbytes for index leaf pages.
With LRU Buffer Replacement Strategy for index leaf pages.
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
FROM TABLE
panorama..InstrumentLeg
LGD
Nested iteration.
Using Clustered Index.
Index : PK__InstrumentLeg__79DD1E2D
Forward scan.
Positioning by key.
Keys are:
InstrumentID ASC
VersionNumber ASC
Using I/O Size 16 Kbytes for index leaf pages.
With LRU Buffer Replacement Strategy for index leaf pages.
Using I/O Size 16 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable1.
Parallel work table merge.
STEP 4
The type of query is SELECT (into Worktable4).
GROUP BY
Evaluate Grouped SUM OR AVERAGE AGGREGATE.
Evaluate Grouped SUM OR AVERAGE AGGREGATE.
Executed by coordinating process.
FROM TABLE
Worktable1.
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 16 Kbytes for data pages.
With MRU Buffer Replacement Strategy for data pages.
TO TABLE
Worktable4.
STEP 5
The type of query is SELECT.
Executed by coordinating process.
FROM TABLE
Worktable4.
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 16 Kbytes for data pages.
With MRU Buffer Replacement Strategy for data pages.
The sort for Worktable2 is done in Serial
The sort for Worktable3 is done in Parallel
Table: InstrumentLeg scan count 6, logical reads: (regular=152882 apf=0 total=152882), physical reads: (regular=13844 apf=0 total=13844), apf IOs used=0
Table: InstrumentLeg scan count 65, logical reads: (regular=224 apf=0 total=224), physical reads: (regular=1 apf=0 total=1), apf IOs used=0
Table: Instrument scan count 1608, logical reads: (regular=9502 apf=0 total=9502), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: ValuationTabResults scan count 3, logical reads: (regular=43686 apf=0 total=43686), physical reads: (regular=4656 apf=0 total=4656), apf IOs used=0
Table: PortfolioResults scan count 7224, logical reads: (regular=9812 apf=0 total=9812), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: PartitionMapData scan count 1, logical reads: (regular=188227 apf=0 total=188227), physical reads: (regular=17384 apf=0 total=17384), apf IOs used=0
Table: RPTRISK_DeskPortfolioMapping scan count 3, logical reads: (regular=3 apf=0 total=3), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable4 scan count 1, logical reads: (regular=21 apf=0 total=21), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable1 scan count 4, logical reads: (regular=325 apf=0 total=325), physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: Worktable2 scan count 1608, logical reads: (regular=20414 apf=0 total=20414), physical reads: (regular=34 apf=0 total=34), apf IOs used=0
Table: Worktable3 scan count 11046, logical reads: (regular=1160127 apf=0 total=1160127), physical reads: (regular=34 apf=0 total=34), apf IOs used=0
Total writes for this command: 9287 |
Partager