-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathplan.html
More file actions
39 lines (38 loc) · 28.7 KB
/
plan.html
File metadata and controls
39 lines (38 loc) · 28.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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<!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="X-UA-Compatible" content="IE=9" />
<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>INSERT</div><div class="qp-tt"><div class="qp-tt-header">INSERT</div><div></div><table><tr><th>Cached plan size</th><td>56 B</td></tr><tr><th>Estimated Subtree Cost</th><td>0.512989</td></tr><tr><th>Estimated Number of Rows</th><td>121.332</td></tr></table><div class="qp-bold">Statement</div><div>insert into SubmissionFileSubmission (SubmissionId, SubmissionFileId )
select distinct SFS.SubmissionId, @SubmissionFileId
from SubmissionFileSubmission SFS (nolock)
LEFT OUTER JOIN SubmissionFileSubmission SFSDupe (nolock)
ON SFS.SubmissionId = SFSDupe.SubmissionId
AND SFSDupe.SubmissionFileId = @SubmissionFileId
where SFS.SubmissionFileId = @ParentSubmissionFileId
AND SFSDupe.SubmissionID IS NULL
</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-Assert"></div><div>Assert</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Assert</div><div></div><table><tr><th>Physical Operation</th><td>Assert</td></tr><tr><th>Logical Operation</th><td>Assert</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.0000825</td></tr><tr><th>Estimated Operator Cost</th><td>0.0000825
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.512989</td></tr><tr><th>Estimated Number of Rows</th><td>121.332</td></tr><tr><th>Estimated Row Size</th><td>9 B</td></tr><tr><th>Node ID</th><td>1</td></tr></table></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-NestedLoops"></div><div>Nested Loops</div><div>(Left Semi Join)</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Nested Loops</div><div>For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.</div><table><tr><th>Physical Operation</th><td>Nested Loops</td></tr><tr><th>Logical Operation</th><td>Left Semi Join</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.0005635</td></tr><tr><th>Estimated Operator Cost</th><td>0.0005635
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.512906</td></tr><tr><th>Estimated Number of Rows</th><td>121.332</td></tr><tr><th>Estimated Row Size</th><td>9 B</td></tr><tr><th>Node ID</th><td>2</td></tr></table><div class="qp-bold">Output List</div><div>Expr1016</div><div>Expr1017</div><div class="qp-bold">Outer References</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].SubmissionId</div><div>Expr1020</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-NestedLoops"></div><div>Nested Loops</div><div>(Left Semi Join)</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Nested Loops</div><div>For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.</div><table><tr><th>Physical Operation</th><td>Nested Loops</td></tr><tr><th>Logical Operation</th><td>Left Semi Join</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.0006261</td></tr><tr><th>Estimated Operator Cost</th><td>0.0006261
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.0728693</td></tr><tr><th>Estimated Number of Rows</th><td>134.813</td></tr><tr><th>Estimated Row Size</th><td>12 B</td></tr><tr><th>Node ID</th><td>5</td></tr></table><div class="qp-bold">Output List</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].SubmissionId</div><div>Expr1016</div><div class="qp-bold">Outer References</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].SubmissionFileId</div><div>Expr1019</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-ClusteredIndexInsert"></div><div>Clustered Index Insert</div><div>(Insert)</div><div>Cost: 4%</div><div class="qp-tt"><div class="qp-tt-header">Clustered Index Insert</div><div></div><table><tr><th>Physical Operation</th><td>Clustered Index Insert</td></tr><tr><th>Logical Operation</th><td>Insert</td></tr><tr><th>Estimated I/O Cost</th><td>0.02</td></tr><tr><th>Estimated CPU Cost</th><td>0.0002996</td></tr><tr><th>Estimated Operator Cost</th><td>0.0202996
(4%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.0539658</td></tr><tr><th>Estimated Number of Rows</th><td>149.793</td></tr><tr><th>Estimated Row Size</th><td>15 B</td></tr><tr><th>Node ID</th><td>7</td></tr></table><div class="qp-bold">Output List</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].SubmissionId</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].SubmissionFileId</div><div class="qp-bold">Object</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[PK_SubmissionFileSubmission]</div><div class="qp-bold">Object</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[XIF2SubmissionFileSubmission]</div><div class="qp-bold">Predicate</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[SubmissionId] = [AVSubmit].[dbo].[SubmissionFileSubmission].[SubmissionId] as [SFS].[SubmissionId],[AVSubmit].[dbo].[SubmissionFileSubmission].[SubmissionFileId] = RaiseIfNullInsert([@SubmissionFileId]),[AVSubmit].[dbo].[SubmissionFileSubmission].[SubmissionFileSubmissionId] = [Expr1007]</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.000015</td></tr><tr><th>Estimated Operator Cost</th><td>0.000015
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.0336662</td></tr><tr><th>Estimated Number of Rows</th><td>149.793</td></tr><tr><th>Estimated Row Size</th><td>19 B</td></tr><tr><th>Node ID</th><td>9</td></tr></table><div class="qp-bold">Output List</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[SFS].SubmissionId</div><div>Expr1007</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-TableSpool"></div><div>Table Spool</div><div>(Eager Spool)</div><div>Cost: 3%</div><div class="qp-tt"><div class="qp-tt-header">Table Spool</div><div></div><table><tr><th>Physical Operation</th><td>Table Spool</td></tr><tr><th>Logical Operation</th><td>Eager Spool</td></tr><tr><th>Estimated I/O Cost</th><td>0.013125</td></tr><tr><th>Estimated CPU Cost</th><td>0.000154</td></tr><tr><th>Estimated Operator Cost</th><td>0.013279
(3%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.0336512</td></tr><tr><th>Estimated Number of Rows</th><td>149.793</td></tr><tr><th>Estimated Row Size</th><td>11 B</td></tr><tr><th>Node ID</th><td>10</td></tr></table><div class="qp-bold">Output List</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[SFS].SubmissionId</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-Filter"></div><div>Filter</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Filter</div><div></div><table><tr><th>Physical Operation</th><td>Filter</td></tr><tr><th>Logical Operation</th><td>Filter</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.0004041</td></tr><tr><th>Estimated Operator Cost</th><td>0.0004041
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.0203722</td></tr><tr><th>Estimated Number of Rows</th><td>149.793</td></tr><tr><th>Estimated Row Size</th><td>11 B</td></tr><tr><th>Node ID</th><td>11</td></tr></table><div class="qp-bold">Output List</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[SFS].SubmissionId</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>(Left Outer Join)</div><div>Cost: 2%</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>Left Outer Join</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.0090626</td></tr><tr><th>Estimated Operator Cost</th><td>0.0090626
(2%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.0199681</td></tr><tr><th>Estimated Number of Rows</th><td>841.97</td></tr><tr><th>Estimated Row Size</th><td>15 B</td></tr><tr><th>Node ID</th><td>12</td></tr></table><div class="qp-bold">Output List</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[SFS].SubmissionId</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[SFSDupe].SubmissionId</div></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-IndexSeek"></div><div>Index Seek</div><div>[SubmissionFileSubmission].[XIF2Sub…</div><div>Cost: 1%</div><div class="qp-tt"><div class="qp-tt-header">Index Seek</div><div>Scan a particular range of rows from a nonclustered index.</div><table><tr><th>Physical Operation</th><td>Index Seek</td></tr><tr><th>Logical Operation</th><td>Index Seek</td></tr><tr><th>Estimated I/O Cost</th><td>0.0046465</td></tr><tr><th>Estimated CPU Cost</th><td>0.0010832</td></tr><tr><th>Estimated Operator Cost</th><td>0.0057296
(1%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.0057296</td></tr><tr><th>Estimated Number of Rows</th><td>841.97</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>13</td></tr></table><div class="qp-bold">Output List</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[SFS].SubmissionId</div><div class="qp-bold">Object</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[XIF2SubmissionFileSubmission].[SFS]</div></div></div></div><div></div></div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-IndexSeek"></div><div>Index Seek</div><div>[SubmissionFileSubmission].[XIF2Sub…</div><div>Cost: 1%</div><div class="qp-tt"><div class="qp-tt-header">Index Seek</div><div>Scan a particular range of rows from a nonclustered index.</div><table><tr><th>Physical Operation</th><td>Index Seek</td></tr><tr><th>Logical Operation</th><td>Index Seek</td></tr><tr><th>Estimated I/O Cost</th><td>0.0042514</td></tr><tr><th>Estimated CPU Cost</th><td>0.0009214</td></tr><tr><th>Estimated Operator Cost</th><td>0.0051728
(1%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.0051728</td></tr><tr><th>Estimated Number of Rows</th><td>694.931</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>14</td></tr></table><div class="qp-bold">Output List</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[SFSDupe].SubmissionId</div><div class="qp-bold">Object</div><div>[AVSubmit].[dbo].[SubmissionFileSubmission].[XIF2SubmissionFileSubmission].[SFSDupe]</div></div></div></div><div></div></div></div></div></div></div></div></div></div></div></div></div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-RowCountSpool"></div><div>Row Count Spool</div><div>(Lazy Spool)</div><div>Cost: 0%</div><div class="qp-tt"><div class="qp-tt-header">Row Count Spool</div><div></div><table><tr><th>Physical Operation</th><td>Row Count Spool</td></tr><tr><th>Logical Operation</th><td>Lazy Spool</td></tr><tr><th>Estimated I/O Cost</th><td>0</td></tr><tr><th>Estimated CPU Cost</th><td>0.0001001</td></tr><tr><th>Estimated Operator Cost</th><td>0.0001001
(0%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.0182773</td></tr><tr><th>Estimated Number of Rows</th><td>1</td></tr><tr><th>Estimated Row Size</th><td>9 B</td></tr><tr><th>Node ID</th><td>20</td></tr></table></div></div></div><div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-ClusteredIndexSeek"></div><div>Clustered Index Seek</div><div>[SubmissionFile].[PK_SubmissionFile…</div><div>Cost: 1%</div><div class="qp-tt"><div class="qp-tt-header">Clustered Index Seek</div><div>Scanning a particular range of rows from a clustered index.</div><table><tr><th>Physical Operation</th><td>Clustered Index Seek</td></tr><tr><th>Logical Operation</th><td>Clustered Index Seek</td></tr><tr><th>Estimated I/O Cost</th><td>0.003125</td></tr><tr><th>Estimated CPU Cost</th><td>0.0001581</td></tr><tr><th>Estimated Operator Cost</th><td>0.0032831
(1%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.0032831</td></tr><tr><th>Estimated Number of Rows</th><td>1</td></tr><tr><th>Estimated Row Size</th><td>9 B</td></tr><tr><th>Ordered</th><td>True</td></tr><tr><th>Node ID</th><td>21</td></tr></table><div class="qp-bold">Object</div><div>[AVSubmit].[dbo].[SubmissionFile].[PK_SubmissionFile]</div></div></div></div><div></div></div></div></div></div></div><div class="qp-tr"><div><div class="qp-node"><div class="qp-icon-ClusteredIndexSeek"></div><div>Clustered Index Seek</div><div>[Submission].[PK_Submission]</div><div>Cost: 1%</div><div class="qp-tt"><div class="qp-tt-header">Clustered Index Seek</div><div>Scanning a particular range of rows from a clustered index.</div><table><tr><th>Physical Operation</th><td>Clustered Index Seek</td></tr><tr><th>Logical Operation</th><td>Clustered Index Seek</td></tr><tr><th>Estimated I/O Cost</th><td>0.003125</td></tr><tr><th>Estimated CPU Cost</th><td>0.0001581</td></tr><tr><th>Estimated Operator Cost</th><td>0.0032831
(1%)
</td></tr><tr><th>Estimated Subtree Cost</th><td>0.439473</td></tr><tr><th>Estimated Number of Rows</th><td>1</td></tr><tr><th>Estimated Row Size</th><td>9 B</td></tr><tr><th>Ordered</th><td>True</td></tr><tr><th>Node ID</th><td>22</td></tr></table><div class="qp-bold">Object</div><div>[AVSubmit].[dbo].[Submission].[PK_Submission]</div></div></div></div><div></div></div></div></div></div></div></div></div></div></div></body></html>