-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathEXEC_OPT.sqlplan
More file actions
91 lines (91 loc) · 13.3 KB
/
EXEC_OPT.sqlplan
File metadata and controls
91 lines (91 loc) · 13.3 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
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
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.539" Build="15.0.2000.5" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="0" StatementEstRows="250" StatementId="1" StatementOptmLevel="TRIVIAL" CardinalityEstimationModelVersion="130" StatementSubTreeCost="0.00377959" StatementText="SELECT [OrderDate],[TotalAmount],[ShipCountry] FROM [dbo].[SalesOrders] WHERE [CustomerID]=@1 AND [OrderStatus]=@2" StatementType="SELECT" QueryHash="0xF2E67B074C71B16F" QueryPlanHash="0x0A6A33DD88C52640" RetrievedFromCache="true" SecurityPolicyApplied="false">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="MaxDOPSetToOne" CachedPlanSize="24" CompileTime="330" CompileCPU="317" CompileMemory="192">
<MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1645522" EstimatedPagesCached="102845" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="6539992" />
<OptimizerStatsUsage>
<StatisticsInfo Database="[PRACT]" Schema="[dbo]" Table="[SalesOrders]" Statistics="[IX_Customer_Status_Cover]" ModificationCount="0" SamplingPercent="100" LastUpdate="2025-12-26T20:45:20.84" />
<StatisticsInfo Database="[PRACT]" Schema="[dbo]" Table="[SalesOrders]" Statistics="[_WA_Sys_00000004_0880433F]" ModificationCount="0" SamplingPercent="34.301" LastUpdate="2025-12-26T20:45:36.63" />
</OptimizerStatsUsage>
<TraceFlags IsCompileTime="true">
<TraceFlag Value="1117" Scope="Global" />
<TraceFlag Value="1118" Scope="Global" />
</TraceFlags>
<TraceFlags IsCompileTime="false">
<TraceFlag Value="1117" Scope="Global" />
<TraceFlag Value="1118" Scope="Global" />
</TraceFlags>
<QueryTimeStats CpuTime="0" ElapsedTime="0" />
<RelOp AvgRowSize="73" EstimateCPU="0.000432" EstimateIO="0.00334759" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="250" EstimatedRowsRead="250" LogicalOp="Index Seek" NodeId="0" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00377959" TableCardinality="500000">
<OutputList>
<ColumnReference Database="[PRACT]" Schema="[dbo]" Table="[SalesOrders]" Column="OrderDate" />
<ColumnReference Database="[PRACT]" Schema="[dbo]" Table="[SalesOrders]" Column="TotalAmount" />
<ColumnReference Database="[PRACT]" Schema="[dbo]" Table="[SalesOrders]" Column="ShipCountry" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="106" ActualRowsRead="106" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="5" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRACT]" Schema="[dbo]" Table="[SalesOrders]" Column="OrderDate" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRACT]" Schema="[dbo]" Table="[SalesOrders]" Column="TotalAmount" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRACT]" Schema="[dbo]" Table="[SalesOrders]" Column="ShipCountry" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRACT]" Schema="[dbo]" Table="[SalesOrders]" Index="[IX_Customer_Status_Cover]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRACT]" Schema="[dbo]" Table="[SalesOrders]" Column="CustomerID" />
<ColumnReference Database="[PRACT]" Schema="[dbo]" Table="[SalesOrders]" Column="OrderStatus" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[@1],0)">
<Identifier>
<ColumnReference Column="ConstExpr1002">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@1" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[@2]">
<Identifier>
<ColumnReference Column="@2" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<ParameterList>
<ColumnReference Column="@2" ParameterDataType="varchar(8000)" ParameterCompiledValue="'C'" ParameterRuntimeValue="'C'" />
<ColumnReference Column="@1" ParameterDataType="tinyint" ParameterCompiledValue="(128)" ParameterRuntimeValue="(128)" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>