Skip to content

Instantly share code, notes, and snippets.

/TadejPlanFast.sqlplan

Created March 15, 2016 07:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/05f47966c7b70f024546 to your computer and use it in GitHub Desktop.
Save anonymous/05f47966c7b70f024546 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
TadejPlanFast.sqlplan
<?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,&#xD;&#xA; CLASSIFICATIONS.TITLE_TEXT, &#xD;&#xA; CLASSIFICATIONS.CFN_UID&#xD;&#xA; FROM klasje.dbo.CLASSIFICATIONS&#xD;&#xA; inner join Klasje.dbo.CFN_VERSIONS on CLASSIFICATIONS.CFN_UID = CFN_VERSIONS.CFN_UID&#xD;&#xA; inner join Klasje.dbo.VERSION_CATEGORY_XREFS on CFN_VERSIONS.CVN_UID = VERSION_CATEGORY_XREFS.CVN_UID&#xD;&#xA; left outer join Klasje.dbo.VELJAVNOST on CFN_VERSIONS.LIFE_CYCLE_CODE = VELJAVNOST.RV_LOW_VALUE&#xD;&#xA; WHERE CATEGORY_CODE like @ccode OR DESCRIPTOR_TEXT like @ccode OR DEFINITION_TEXT like @ccode&#xD;&#xA; ORDER BY ABBREV_TEXT&#xD;&#xA; 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>
Raw
TadejPlanSlow.sqlplan
<?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,&#xD;&#xA; CLASSIFICATIONS.TITLE_TEXT, &#xD;&#xA; CLASSIFICATIONS.CFN_UID&#xD;&#xA; FROM klasje.dbo.CLASSIFICATIONS&#xD;&#xA; inner join Klasje.dbo.CFN_VERSIONS on CLASSIFICATIONS.CFN_UID = CFN_VERSIONS.CFN_UID&#xD;&#xA; inner join Klasje.dbo.VERSION_CATEGORY_XREFS on CFN_VERSIONS.CVN_UID = VERSION_CATEGORY_XREFS.CVN_UID&#xD;&#xA; left outer join Klasje.dbo.VELJAVNOST on CFN_VERSIONS.LIFE_CYCLE_CODE = VELJAVNOST.RV_LOW_VALUE&#xD;&#xA; WHERE CATEGORY_CODE like @ccode OR DESCRIPTOR_TEXT like @ccode OR DEFINITION_TEXT like @ccode&#xD;&#xA; ORDER BY ABBREV_TEXT&#xD;&#xA; 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