Guest User

UsersKeyLookup_Zikato

a guest
Jul 19th, 2022
271
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 4.33 KB | None | 0 0
  1. SELECT CAST(N'<?xml version="1.0" encoding="utf-16"?>
  2. <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.539" Build="15.0.4198.2" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  3.  <BatchSequence>
  4.    <Batch>
  5.      <Statements>
  6.        <StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="TRIVIAL" CardinalityEstimationModelVersion="70" StatementSubTreeCost="100" StatementText="SELECT [u].[Id] FROM [dbo].[Users] [u] WHERE [u].[Id]=@1" StatementType="SELECT" QueryHash="0x75E7358915BFBCCE" QueryPlanHash="0x9733737E5989BD0C" RetrievedFromCache="true" SecurityPolicyApplied="false">
  7.          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
  8.          <QueryPlan DegreeOfParallelism="1" CachedPlanSize="16" CompileTime="0" CompileCPU="0" CompileMemory="112">
  9.            <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0" />
  10.            <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="26214" EstimatedPagesCached="18849" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="2075472" />
  11.            <QueryTimeStats CpuTime="0" ElapsedTime="0" />
  12.            <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Clustered Index Seek" NodeId="0" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="54" TableCardinality="299398">
  13.              <OutputList>
  14.                <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
  15.              </OutputList>
  16.              <RunTimeInformation>
  17.                <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualRowsRead="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
  18.              </RunTimeInformation>
  19.              <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
  20.                <DefinedValues>
  21.                  <DefinedValue>
  22.                    <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
  23.                  </DefinedValue>
  24.                </DefinedValues>
  25.                <Object Database="[StackOverflow]" Schema="[dbo]" Table="[Users]" Index="[PK_Users_Id]" Alias="[u]" IndexKind="Clustered" Storage="RowStore" />
  26.                <SeekPredicates>
  27.                  <SeekPredicateNew>
  28.                    <SeekKeys>
  29.                      <Prefix ScanType="EQ">
  30.                        <RangeColumns>
  31.                          <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" />
  32.                        </RangeColumns>
  33.                        <RangeExpressions>
  34.                          <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[@1],0)">
  35.                            <Convert DataType="int" Style="0" Implicit="true">
  36.                              <ScalarOperator>
  37.                                <Identifier>
  38.                                  <ColumnReference Column="@1" />
  39.                                </Identifier>
  40.                              </ScalarOperator>
  41.                            </Convert>
  42.                          </ScalarOperator>
  43.                        </RangeExpressions>
  44.                      </Prefix>
  45.                    </SeekKeys>
  46.                  </SeekPredicateNew>
  47.                </SeekPredicates>
  48.              </IndexScan>
  49.            </RelOp>
  50.            <ParameterList>
  51.              <ColumnReference Column="@1" ParameterDataType="tinyint" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />
  52.            </ParameterList>
  53.          </QueryPlan>
  54.        </StmtSimple>
  55.      </Statements>
  56.    </Batch>
  57.  </BatchSequence>
  58. </ShowPlanXML>' AS xml) AS [Execution plan]
Advertisement
Add Comment
Please, Sign In to add comment