Created
March 15, 2016 07:55
-
-
Save anonymous/05f47966c7b70f024546 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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.2" Build="12.0.2000.8" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
<BatchSequence> | |
<Batch> | |
<Statements> | |
<StmtSimple StatementCompId="4" StatementEstRows="100" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="120" StatementSubTreeCost="22.2769" StatementText="SELECT DISTINCT CLASSIFICATIONS.ABBREV_TEXT,
 CLASSIFICATIONS.TITLE_TEXT, 
 CLASSIFICATIONS.CFN_UID
 FROM klasje.dbo.CLASSIFICATIONS
 inner join Klasje.dbo.CFN_VERSIONS on CLASSIFICATIONS.CFN_UID = CFN_VERSIONS.CFN_UID
 inner join Klasje.dbo.VERSION_CATEGORY_XREFS on CFN_VERSIONS.CVN_UID = VERSION_CATEGORY_XREFS.CVN_UID
 left outer join Klasje.dbo.VELJAVNOST on CFN_VERSIONS.LIFE_CYCLE_CODE = VELJAVNOST.RV_LOW_VALUE
 WHERE CATEGORY_CODE like @ccode OR DESCRIPTOR_TEXT like @ccode OR DEFINITION_TEXT like @ccode
 ORDER BY ABBREV_TEXT
 OFFSET @PageSize * (@PageNumber - 1) ROWS FETCH NEXT @PageSize ROWS ONLY" StatementType="SELECT" QueryHash="0xF15DFB9E87348D01" QueryPlanHash="0x58F303873F9AEB8D" RetrievedFromCache="true"> | |
<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="4" MemoryGrant="15680" CachedPlanSize="104" CompileTime="46" CompileCPU="46" CompileMemory="1528"> | |
<ThreadStat Branches="4" UsedThreads="16"> | |
<ThreadReservation NodeId="0" ReservedThreads="16" /> | |
</ThreadStat> | |
<MemoryGrantInfo SerialRequiredMemory="3072" SerialDesiredMemory="4624" RequiredMemory="14112" DesiredMemory="15680" RequestedMemory="15680" GrantWaitTime="0" GrantedMemory="15680" MaxUsedMemory="3312" /> | |
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419419" EstimatedPagesCached="104854" EstimatedAvailableDegreeOfParallelism="2" /> | |
<RelOp AvgRowSize="64" EstimateCPU="1E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="22.2769"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<Top RowCount="false" IsPercent="false" WithTies="false"> | |
<OffsetExpression> | |
<ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[@PageSize]*([@PageNumber]-(1)),0)"> | |
<Identifier> | |
<ColumnReference Column="ConstExpr1021"> | |
<ScalarOperator> | |
<Convert DataType="bigint" Style="0" Implicit="true"> | |
<ScalarOperator> | |
<Arithmetic Operation="MULT"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@PageSize" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Arithmetic Operation="SUB"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@PageNumber" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Arithmetic> | |
</ScalarOperator> | |
</Arithmetic> | |
</ScalarOperator> | |
</Convert> | |
</ScalarOperator> | |
</ColumnReference> | |
</Identifier> | |
</ScalarOperator> | |
</OffsetExpression> | |
<TopExpression> | |
<ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[@PageSize],0)"> | |
<Identifier> | |
<ColumnReference Column="ConstExpr1020"> | |
<ScalarOperator> | |
<Convert DataType="bigint" Style="0" Implicit="true"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@PageSize" /> | |
</Identifier> | |
</ScalarOperator> | |
</Convert> | |
</ScalarOperator> | |
</ColumnReference> | |
</Identifier> | |
</ScalarOperator> | |
</TopExpression> | |
<RelOp AvgRowSize="64" EstimateCPU="0.0293325" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="22.2768"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<Parallelism> | |
<OrderBy> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="64" EstimateCPU="0.0147655" EstimateIO="0.00563063" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Distinct Sort" NodeId="2" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="22.2475"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<MemoryFractions Input="0.237113" Output="1" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="2" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="2" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<Sort Distinct="true"> | |
<OrderBy> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
</OrderByColumn> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OrderByColumn> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="64" EstimateCPU="0.0407399" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1751.06" LogicalOp="Repartition Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="22.2271"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="2" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="11" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<Parallelism PartitioningType="Hash"> | |
<PartitionColumns> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
</PartitionColumns> | |
<RelOp AvgRowSize="64" EstimateCPU="0.103313" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1751.06" LogicalOp="Inner Join" NodeId="4" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="22.1864"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<MemoryFractions Input="0.43956" Output="0.412371" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="4" ActualRows="12" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<Hash> | |
<DefinedValues /> | |
<HashKeysBuild> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
</HashKeysBuild> | |
<HashKeysProbe> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CFN_UID" /> | |
</HashKeysProbe> | |
<ProbeResidual> | |
<ScalarOperator ScalarString="[Klasje].[dbo].[CFN_VERSIONS].[CFN_UID]=[Klasje].[dbo].[CLASSIFICATIONS].[CFN_UID]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CFN_UID" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</ProbeResidual> | |
<RelOp AvgRowSize="64" EstimateCPU="0.0336036" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1444" LogicalOp="Repartition Streams" NodeId="5" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0628258"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="375" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="358" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="324" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="387" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<Parallelism PartitioningType="Hash"> | |
<PartitionColumns> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
</PartitionColumns> | |
<RelOp AvgRowSize="64" EstimateCPU="0.00083345" EstimateIO="0.0283887" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1444" LogicalOp="Table Scan" NodeId="6" Parallel="true" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0292221" TableCardinality="1444"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="1" ActualRows="301" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="4" ActualRows="485" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="243" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="415" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" IndexKind="Heap" Storage="RowStore" /> | |
</TableScan> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
<RelOp AvgRowSize="12" EstimateCPU="0.0307017" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1751.06" LogicalOp="Repartition Streams" NodeId="7" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="22.0202"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CFN_UID" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="12" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<Parallelism PartitioningType="Hash"> | |
<PartitionColumns> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CFN_UID" /> | |
</PartitionColumns> | |
<RelOp AvgRowSize="12" EstimateCPU="0.0383023" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1751.06" LogicalOp="Inner Join" NodeId="8" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="21.9895"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CFN_UID" /> | |
</OutputList> | |
<MemoryFractions Input="0.373626" Output="0.350515" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="1" ActualRows="5" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="5" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="4" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<Hash> | |
<DefinedValues /> | |
<HashKeysBuild> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</HashKeysBuild> | |
<HashKeysProbe> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CVN_UID" /> | |
</HashKeysProbe> | |
<ProbeResidual> | |
<ScalarOperator ScalarString="[Klasje].[dbo].[VERSION_CATEGORY_XREFS].[CVN_UID]=[Klasje].[dbo].[CFN_VERSIONS].[CVN_UID]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CVN_UID" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</ProbeResidual> | |
<RelOp AvgRowSize="12" EstimateCPU="0.713974" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1819.14" LogicalOp="Aggregate" NodeId="9" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="21.9014"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</OutputList> | |
<MemoryFractions Input="0.56044" Output="0.186813" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="1" ActualRows="5" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="5" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="4" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<Hash> | |
<DefinedValues /> | |
<HashKeysBuild> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</HashKeysBuild> | |
<BuildResidual> | |
<ScalarOperator ScalarString="[Klasje].[dbo].[VERSION_CATEGORY_XREFS].[CVN_UID] = [Klasje].[dbo].[VERSION_CATEGORY_XREFS].[CVN_UID]"> | |
<Compare CompareOp="IS"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</BuildResidual> | |
<RelOp AvgRowSize="12" EstimateCPU="0.290746" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="208566" LogicalOp="Repartition Streams" NodeId="10" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="21.1874"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="1" ActualRows="9" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="4" ActualRows="3" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="11" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<Parallelism PartitioningType="Hash"> | |
<PartitionColumns> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</PartitionColumns> | |
<RelOp AvgRowSize="2154" EstimateCPU="0.754047" EstimateIO="18.5113" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="208566" LogicalOp="Clustered Index Scan" NodeId="11" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="19.2653" TableCardinality="1370850"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="1" ActualRows="7" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="6" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="4" ActualRows="7" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="4" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Index="[IX_VERSION_CATEGORY_XREFS]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" /> | |
<Predicate> | |
<ScalarOperator ScalarString="[Klasje].[dbo].[VERSION_CATEGORY_XREFS].[CATEGORY_CODE] like [@ccode] OR [Klasje].[dbo].[VERSION_CATEGORY_XREFS].[DESCRIPTOR_TEXT] like [@ccode] OR [Klasje].[dbo].[VERSION_CATEGORY_XREFS].[DEFINITION_TEXT] like [@ccode]"> | |
<Logical Operation="OR"> | |
<ScalarOperator> | |
<Intrinsic FunctionName="like"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CATEGORY_CODE" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@ccode" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Intrinsic FunctionName="like"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="DESCRIPTOR_TEXT" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@ccode" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Intrinsic FunctionName="like"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="DEFINITION_TEXT" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@ccode" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
</Logical> | |
</ScalarOperator> | |
</Predicate> | |
</IndexScan> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
</Hash> | |
</RelOp> | |
<RelOp AvgRowSize="17" EstimateCPU="0.0315519" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1826" LogicalOp="Repartition Streams" NodeId="13" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0498731"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CVN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CFN_UID" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="1" ActualRows="449" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="469" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="4" ActualRows="442" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="466" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<Parallelism PartitioningType="Hash"> | |
<PartitionColumns> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CVN_UID" /> | |
</PartitionColumns> | |
<RelOp AvgRowSize="17" EstimateCPU="0.00104355" EstimateIO="0.0172776" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1826" LogicalOp="Table Scan" NodeId="14" Parallel="true" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0183211" TableCardinality="1826"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CVN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CFN_UID" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="2" ActualRows="509" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="406" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="508" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="4" ActualRows="403" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" /> | |
</RunTimeInformation> | |
<TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CVN_UID" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CFN_UID" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" IndexKind="Heap" Storage="RowStore" /> | |
</TableScan> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
</Hash> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
</Hash> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
</Sort> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
</Top> | |
</RelOp> | |
<ParameterList> | |
<ColumnReference Column="@PageNumber" ParameterRuntimeValue="(1)" /> | |
<ColumnReference Column="@PageSize" ParameterRuntimeValue="(20)" /> | |
<ColumnReference Column="@ccode" ParameterRuntimeValue="'%skd%'" /> | |
</ParameterList> | |
</QueryPlan> | |
</StmtSimple> | |
</Statements> | |
</Batch> | |
</BatchSequence> | |
</ShowPlanXML> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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.2" Build="12.0.2000.8" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
<BatchSequence> | |
<Batch> | |
<Statements> | |
<StmtSimple StatementCompId="4" StatementEstRows="100" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="70" StatementSubTreeCost="3.43441" StatementText="SELECT DISTINCT CLASSIFICATIONS.ABBREV_TEXT,
 CLASSIFICATIONS.TITLE_TEXT, 
 CLASSIFICATIONS.CFN_UID
 FROM klasje.dbo.CLASSIFICATIONS
 inner join Klasje.dbo.CFN_VERSIONS on CLASSIFICATIONS.CFN_UID = CFN_VERSIONS.CFN_UID
 inner join Klasje.dbo.VERSION_CATEGORY_XREFS on CFN_VERSIONS.CVN_UID = VERSION_CATEGORY_XREFS.CVN_UID
 left outer join Klasje.dbo.VELJAVNOST on CFN_VERSIONS.LIFE_CYCLE_CODE = VELJAVNOST.RV_LOW_VALUE
 WHERE CATEGORY_CODE like @ccode OR DESCRIPTOR_TEXT like @ccode OR DEFINITION_TEXT like @ccode
 ORDER BY ABBREV_TEXT
 OFFSET @PageSize * (@PageNumber - 1) ROWS FETCH NEXT @PageSize ROWS ONLY" StatementType="SELECT" QueryHash="0xF15DFB9E87348D01" QueryPlanHash="0xF2BCA1BEEE562EEB" RetrievedFromCache="true"> | |
<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="1" MemoryGrant="1024" CachedPlanSize="64" CompileTime="35" CompileCPU="35" CompileMemory="1776"> | |
<MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="832" RequiredMemory="512" DesiredMemory="832" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="160" /> | |
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419419" EstimatedPagesCached="104854" EstimatedAvailableDegreeOfParallelism="2" /> | |
<RelOp AvgRowSize="64" EstimateCPU="1E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="3.43441"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<Top RowCount="false" IsPercent="false" WithTies="false"> | |
<OffsetExpression> | |
<ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[@PageSize]*([@PageNumber]-(1)),0)"> | |
<Identifier> | |
<ColumnReference Column="ConstExpr1021"> | |
<ScalarOperator> | |
<Convert DataType="bigint" Style="0" Implicit="true"> | |
<ScalarOperator> | |
<Arithmetic Operation="MULT"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@PageSize" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Arithmetic Operation="SUB"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@PageNumber" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Arithmetic> | |
</ScalarOperator> | |
</Arithmetic> | |
</ScalarOperator> | |
</Convert> | |
</ScalarOperator> | |
</ColumnReference> | |
</Identifier> | |
</ScalarOperator> | |
</OffsetExpression> | |
<TopExpression> | |
<ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[@PageSize],0)"> | |
<Identifier> | |
<ColumnReference Column="ConstExpr1020"> | |
<ScalarOperator> | |
<Convert DataType="bigint" Style="0" Implicit="true"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@PageSize" /> | |
</Identifier> | |
</ScalarOperator> | |
</Convert> | |
</ScalarOperator> | |
</ColumnReference> | |
</Identifier> | |
</ScalarOperator> | |
</TopExpression> | |
<RelOp AvgRowSize="64" EstimateCPU="0.115243" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Aggregate" NodeId="1" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="3.4344"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<StreamAggregate> | |
<DefinedValues /> | |
<GroupBy> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
</GroupBy> | |
<RelOp AvgRowSize="114" EstimateCPU="5.08904" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1056.44" LogicalOp="Inner Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="3.43178"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="24" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false" WithOrderedPrefetch="true"> | |
<OuterReferences> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="VCX_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
<ColumnReference Column="Expr1025" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="110" EstimateCPU="5.08904" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1056.44" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.113476"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="VCX_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="1366727" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false" WithOrderedPrefetch="true"> | |
<OuterReferences> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CVN_UID" /> | |
<ColumnReference Column="Expr1024" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="69" EstimateCPU="11.0216" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.44973" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0867125"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CVN_UID" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="1826" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false"> | |
<Predicate> | |
<ScalarOperator ScalarString="[Klasje].[dbo].[CLASSIFICATIONS].[CFN_UID]=[Klasje].[dbo].[CFN_VERSIONS].[CFN_UID]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CFN_UID" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Predicate> | |
<RelOp AvgRowSize="64" EstimateCPU="0.0237434" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.25301" LogicalOp="Sort" NodeId="7" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0650603"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<MemoryFractions Input="1" Output="1" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="1444" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<Sort Distinct="false"> | |
<OrderBy> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
</OrderByColumn> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OrderByColumn> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="64" EstimateCPU="0.0017454" EstimateIO="0.0283102" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1444" LogicalOp="Table Scan" NodeId="8" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0300556" TableCardinality="1444"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="1444" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="CFN_UID" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="ABBREV_TEXT" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" Column="TITLE_TEXT" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[Klasje]" Schema="[dbo]" Table="[CLASSIFICATIONS]" IndexKind="Heap" Storage="RowStore" /> | |
</TableScan> | |
</RelOp> | |
</Sort> | |
</RelOp> | |
<RelOp AvgRowSize="17" EstimateCPU="0.0020871" EstimateIO="0.0172776" EstimateRebinds="0" EstimateRewinds="1.25214" EstimatedExecutionMode="Row" EstimateRows="1826" LogicalOp="Table Scan" NodeId="9" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.021978" TableCardinality="1826"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CVN_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CFN_UID" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="2636744" ActualEndOfScans="1444" ActualExecutions="1444" /> | |
</RunTimeInformation> | |
<TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CVN_UID" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CFN_UID" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" IndexKind="Heap" Storage="RowStore" /> | |
</TableScan> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
<RelOp AvgRowSize="55" EstimateCPU="0.000958588" EstimateIO="0.00608796" EstimateRebinds="1.44912" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="728.716" LogicalOp="Index Seek" NodeId="11" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0172502" TableCardinality="1370850"> | |
<OutputList> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="VCX_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="1366727" ActualEndOfScans="1826" ActualExecutions="1826" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="VCX_UID" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Index="[IX_TAdejMatejTest2]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[Klasje].[dbo].[CFN_VERSIONS].[CVN_UID]"> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[CFN_VERSIONS]" Column="CVN_UID" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
<RelOp AvgRowSize="2020" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1056.39" EstimateRewinds="0.0564027" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Clustered Index Seek" NodeId="13" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="3.31389" TableCardinality="1370850"> | |
<OutputList /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="24" ActualEndOfScans="1366703" ActualExecutions="1366727" /> | |
</RunTimeInformation> | |
<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues /> | |
<Object Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Index="[IX_VERSION_CATEGORY_XREFS]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="VCX_UID" /> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[Klasje].[dbo].[VERSION_CATEGORY_XREFS].[VCX_UID]"> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="VCX_UID" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator ScalarString="[Klasje].[dbo].[VERSION_CATEGORY_XREFS].[CVN_UID]"> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CVN_UID" /> | |
</Identifier> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
<Predicate> | |
<ScalarOperator ScalarString="[Klasje].[dbo].[VERSION_CATEGORY_XREFS].[CATEGORY_CODE] like [@ccode] OR [Klasje].[dbo].[VERSION_CATEGORY_XREFS].[DESCRIPTOR_TEXT] like [@ccode] OR [Klasje].[dbo].[VERSION_CATEGORY_XREFS].[DEFINITION_TEXT] like [@ccode]"> | |
<Logical Operation="OR"> | |
<ScalarOperator> | |
<Intrinsic FunctionName="like"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="CATEGORY_CODE" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@ccode" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Intrinsic FunctionName="like"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="DESCRIPTOR_TEXT" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@ccode" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Intrinsic FunctionName="like"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[Klasje]" Schema="[dbo]" Table="[VERSION_CATEGORY_XREFS]" Column="DEFINITION_TEXT" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="@ccode" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
</Logical> | |
</ScalarOperator> | |
</Predicate> | |
</IndexScan> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
</StreamAggregate> | |
</RelOp> | |
</Top> | |
</RelOp> | |
<ParameterList> | |
<ColumnReference Column="@PageNumber" ParameterRuntimeValue="(1)" /> | |
<ColumnReference Column="@PageSize" ParameterRuntimeValue="(20)" /> | |
<ColumnReference Column="@ccode" ParameterRuntimeValue="'%skd%'" /> | |
</ParameterList> | |
</QueryPlan> | |
</StmtSimple> | |
</Statements> | |
</Batch> | |
</BatchSequence> | |
</ShowPlanXML> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment