-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathPlanFromExternalApp.html
More file actions
25 lines (25 loc) · 19.7 KB
/
Copy pathPlanFromExternalApp.html
File metadata and controls
25 lines (25 loc) · 19.7 KB
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
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-16">
<title>Execution plan</title><link rel="stylesheet" type="text/css" href="qp.css"><script src="jquery.min.js" type="text/javascript"></script><script src="qp.js" type="text/javascript"></script><script type="text/javascript">$(document).ready( function() { QP.drawLines(); });</script></head><body><div><div class="qp-root"><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-Statement"></div><div>SELECT</div><div class="qp-tt"><div class="qp-tt-header">SELECT</div><div></div><table><tr><th>Cached plan size</th><td>40 B</td></tr><tr><th>Estimated Subtree Cost</th><td>125.071</td></tr><tr><th>Estimated Number of Rows</th><td>21729.4</td></tr></table><div class="qp-bold">Statement</div><div>SELECT p.ProductId,SUM(h.ActualCost)
FROM bigProduct AS p
INNER JOIN bigTransactionHistory AS h
ON h.ProductId = p.ProductId
GROUP BY p.ProductId</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-GatherStreams"></div><div>Parallelism</div><div>(Gather Streams)</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Parallelism</div><div>An operation involving parallelism.</div><table><tr><th>Physical Operation</th><td>Parallelism</td></tr><tr><th>Logical Operation</th><td>Gather Streams</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.0600061</td></tr><tr><th>Estimated Operator Cost</th><td>0.0600061
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>125.071</td></tr><tr><th>Estimated Number of Rows</th><td>21664.8</td></tr><tr><th>Estimated Row Size</th><td>19 B</td></tr><tr><th>Node ID</th><td>1</td></tr></table><div class="qp-bold">Output List</div><div>[AdventureWorks2012].[dbo].[bigProduct].[p].ProductID</div><div>Expr1002</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-MergeJoin"></div><div>Merge Join</div><div>(Inner Join)</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Merge Join</div><div></div><table><tr><th>Physical Operation</th><td>Merge Join</td></tr><tr><th>Logical Operation</th><td>Inner Join</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.0568032</td></tr><tr><th>Estimated Operator Cost</th><td>0.0568032
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>125.011</td></tr><tr><th>Estimated Number of Rows</th><td>21664.8</td></tr><tr><th>Estimated Row Size</th><td>19 B</td></tr><tr><th>Node ID</th><td>2</td></tr></table><div class="qp-bold">Output List</div><div>[AdventureWorks2012].[dbo].[bigProduct].[p].ProductID</div><div>Expr1002</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-RepartitionStreams"></div><div>Parallelism</div><div>(Repartition Streams)</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Parallelism</div><div>An operation involving parallelism.</div><table><tr><th>Physical Operation</th><td>Parallelism</td></tr><tr><th>Logical Operation</th><td>Repartition Streams</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.184693</td></tr><tr><th>Estimated Operator Cost</th><td>0.184693
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.64546</td></tr><tr><th>Estimated Number of Rows</th><td>25200</td></tr><tr><th>Estimated Row Size</th><td>11 B</td></tr><tr><th>Node ID</th><td>3</td></tr></table><div class="qp-bold">Output List</div><div>[AdventureWorks2012].[dbo].[bigProduct].[p].ProductID</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-ClusteredIndexScan"></div><div>Clustered Index Scan</div><div>[bigProduct].[pk_bigProduct].[p]</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Clustered Index Scan</div><div>Scanning a clustered index, entirely or only a range.</div><table><tr><th>Physical Operation</th><td>Clustered Index Scan</td></tr><tr><th>Logical Operation</th><td>Clustered Index Scan</td></tr><tr><th>Estimated I/O Cost</th><td>0.446829</td></tr><tr><th>Estimated CPU Cost</th><td>0.0139385</td></tr><tr><th>Estimated Operator Cost</th><td>0.4607675
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.460767</td></tr><tr><th>Estimated Number of Rows</th><td>25200</td></tr><tr><th>Estimated Row Size</th><td>11 B</td></tr><tr><th>Ordered</th><td>True</td></tr><tr><th>Node ID</th><td>4</td></tr></table><div class="qp-bold">Output List</div><div>[AdventureWorks2012].[dbo].[bigProduct].[p].ProductID</div><div class="qp-bold">Object</div><div>[AdventureWorks2012].[dbo].[bigProduct].[pk_bigProduct].[p]</div></div></div></div><div></div></div></div></div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-ComputeScalar"></div><div>Compute Scalar</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Compute Scalar</div><div>Compute new values from existing values in a row.</div><table><tr><th>Physical Operation</th><td>Compute Scalar</td></tr><tr><th>Logical Operation</th><td>Compute Scalar</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.00126</td></tr><tr><th>Estimated Operator Cost</th><td>0.00126
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>124.309</td></tr><tr><th>Estimated Number of Rows</th><td>25200</td></tr><tr><th>Estimated Row Size</th><td>19 B</td></tr><tr><th>Node ID</th><td>6</td></tr></table><div class="qp-bold">Output List</div><div>[AdventureWorks2012].[dbo].[bigTransactionHistory].[h].ProductID</div><div>Expr1002</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-StreamAggregate"></div><div>Stream Aggregate</div><div>(Aggregate)</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Stream Aggregate</div><div>Compute summary values for groups of rows in a suitably sorted stream.</div><table><tr><th>Physical Operation</th><td>Stream Aggregate</td></tr><tr><th>Logical Operation</th><td>Aggregate</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.02142</td></tr><tr><th>Estimated Operator Cost</th><td>0.02142
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>124.307</td></tr><tr><th>Estimated Number of Rows</th><td>25200</td></tr><tr><th>Estimated Row Size</th><td>27 B</td></tr><tr><th>Node ID</th><td>7</td></tr></table><div class="qp-bold">Output List</div><div>[AdventureWorks2012].[dbo].[bigTransactionHistory].[h].ProductID</div><div>globalagg1004</div><div>globalagg1006</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-RepartitionStreams"></div><div>Parallelism</div><div>(Repartition Streams)</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Parallelism</div><div>An operation involving parallelism.</div><table><tr><th>Physical Operation</th><td>Parallelism</td></tr><tr><th>Logical Operation</th><td>Repartition Streams</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.39305</td></tr><tr><th>Estimated Operator Cost</th><td>0.39305
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>124.286</td></tr><tr><th>Estimated Number of Rows</th><td>50400</td></tr><tr><th>Estimated Row Size</th><td>27 B</td></tr><tr><th>Node ID</th><td>8</td></tr></table><div class="qp-bold">Output List</div><div>[AdventureWorks2012].[dbo].[bigTransactionHistory].[h].ProductID</div><div>partialagg1003</div><div>partialagg1005</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-StreamAggregate"></div><div>Stream Aggregate</div><div>(Aggregate)</div><div>Cost: 8%</div><div class="qp-tt"><div class="qp-tt-header">Stream Aggregate</div><div>Compute summary values for groups of rows in a suitably sorted stream.</div><table><tr><th>Physical Operation</th><td>Stream Aggregate</td></tr><tr><th>Logical Operation</th><td>Aggregate</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>9.39168</td></tr><tr><th>Estimated Operator Cost</th><td>9.39168
(8%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>123.893</td></tr><tr><th>Estimated Number of Rows</th><td>50400</td></tr><tr><th>Estimated Row Size</th><td>27 B</td></tr><tr><th>Node ID</th><td>9</td></tr></table><div class="qp-bold">Output List</div><div>[AdventureWorks2012].[dbo].[bigTransactionHistory].[h].ProductID</div><div>partialagg1003</div><div>partialagg1005</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-IndexScan"></div><div>Index Scan</div><div>[bigTransactionHistory].[IX_Product…</div><div>Cost: 92%</div><div class="qp-tt"><div class="qp-tt-header">Index Scan</div><div></div><table><tr><th>Physical Operation</th><td>Index Scan</td></tr><tr><th>Logical Operation</th><td>Index Scan</td></tr><tr><th>Estimated I/O Cost</th><td>97.3061</td></tr><tr><th>Estimated CPU Cost</th><td>17.1951</td></tr><tr><th>Estimated Operator Cost</th><td>114.5012
(92%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>114.501</td></tr><tr><th>Estimated Number of Rows</th><td>3.12636e+007</td></tr><tr><th>Estimated Row Size</th><td>19 B</td></tr><tr><th>Ordered</th><td>True</td></tr><tr><th>Node ID</th><td>10</td></tr></table><div class="qp-bold">Output List</div><div>[AdventureWorks2012].[dbo].[bigTransactionHistory].[h].ProductID</div><div>[AdventureWorks2012].[dbo].[bigTransactionHistory].[h].ActualCost</div><div class="qp-bold">Object</div><div>[AdventureWorks2012].[dbo].[bigTransactionHistory].[IX_ProductId_TransactionDate].[h]</div></div></div></div><div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></body></html>