<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.539" Build="15.0.2000.5" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="70" StatementSubTreeCost="178.704" StatementText="select &#xA;&quot;businessprocessflowinstance0&quot;.ModifiedOn as &quot;modifiedon&quot;&#xD;&#xA;, &quot;businessprocessflowinstance0&quot;.ProcessId as &quot;processid&quot;&#xD;&#xA;, &quot;businessprocessflowinstance0&quot;.BusinessProcessFlowInstanceId as &quot;businessprocessflowinstanceid&quot; &#xA;from&#xA; BusinessProcessFlowInstanceBase as &quot;businessprocessflowinstance0&quot; &#xA;where&#xA; (((&quot;businessprocessflowinstance0&quot;.Entity1Id = 'DBD23C1E-D89E-EB11-8147-0050569F2515' and&#xD;&#xA; &quot;businessprocessflowinstance0&quot;.Entity1ObjectTypeCode = 112)&#xD;&#xA; or (&quot;businessprocessflowinstance0&quot;.Entity2Id = null and &quot;businessprocessflowinstance0&quot;.Entity2ObjectTypeCode = null)&#xD;&#xA; or (&quot;businessprocessflowinstance0&quot;.Entity3Id = null and &quot;businessprocessflowinstance0&quot;.Entity3ObjectTypeCode = null)&#xD;&#xA; or (&quot;businessprocessflowinstance0&quot;.Entity4Id = null and &quot;businessprocessflowinstance0&quot;.Entity4ObjectTypeCode = null)&#xD;&#xA; or (&quot;businessprocessflowinstance0&quot;.Entity5Id = null and &quot;businessprocessflowinstance0&quot;.Entity5ObjectTypeCode = null)))" StatementType="SELECT" QueryHash="0xCEDD7A35BA52C1E1" QueryPlanHash="0x02071C998C65DF53" RetrievedFromCache="true" SecurityPolicyApplied="false">
          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
          <QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="MaxDOPSetToOne" MemoryGrant="1024" CachedPlanSize="32" CompileTime="2" CompileCPU="2" CompileMemory="264">
            <Warnings>
              <MemoryGrantWarning GrantWarningKind="Excessive Grant" RequestedMemory="1024" GrantedMemory="1024" MaxUsedMemory="0" />
            </Warnings>
            <MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="0" MaxQueryMemory="137206272" LastRequestedMemory="0" IsMemoryGrantFeedbackAdjusted="No: First Execution" />
            <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="3670016" EstimatedPagesCached="4587520" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="531669440" />
            <WaitStats>
              <Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="81251" WaitCount="777" />
            </WaitStats>
            <QueryTimeStats CpuTime="3118" ElapsedTime="84364" />
            <RelOp AvgRowSize="47" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="0" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="178.704">
              <OutputList>
                <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="BusinessProcessFlowInstanceId" />
                <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="ProcessId" />
                <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="ModifiedOn" />
              </OutputList>
              <MemoryFractions Input="0" Output="1" />
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="84364" ActualCPUms="3117" InputMemoryGrant="0" OutputMemoryGrant="1024" UsedMemoryGrant="0" />
              </RunTimeInformation>
              <NestedLoops Optimized="true">
                <OuterReferences>
                  <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="BusinessProcessFlowInstanceId" />
                </OuterReferences>
                <RelOp AvgRowSize="59" EstimateCPU="20.3757" EstimateIO="138.32" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="18523200" LogicalOp="Index Scan" NodeId="2" Parallel="false" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="158.696" TableCardinality="18523200">
                  <OutputList>
                    <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="BusinessProcessFlowInstanceId" />
                    <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="ProcessId" />
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualRowsRead="18523204" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="84363" ActualCPUms="3117" ActualScans="1" ActualLogicalReads="188632" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
                  </RunTimeInformation>
                  <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
                    <DefinedValues>
                      <DefinedValue>
                        <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="BusinessProcessFlowInstanceId" />
                      </DefinedValue>
                      <DefinedValue>
                        <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="ProcessId" />
                      </DefinedValue>
                    </DefinedValues>
                    <Object Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Index="[cndx_Entity1_ProcessId]" Alias="[businessprocessflowinstance0]" IndexKind="NonClustered" Storage="RowStore" />
                    <Predicate>
                      <ScalarOperator ScalarString="[sso_MSCRM].[dbo].[BusinessProcessFlowInstanceBase].[Entity1Id] as [businessprocessflowinstance0].[Entity1Id]={guid'DBD23C1E-D89E-EB11-8147-0050569F2515'} AND [sso_MSCRM].[dbo].[BusinessProcessFlowInstanceBase].[Entity1ObjectTypeCode] as [businessprocessflowinstance0].[Entity1ObjectTypeCode]=(112) OR NULL">
                        <Logical Operation="OR">
                          <ScalarOperator>
                            <Logical Operation="AND">
                              <ScalarOperator>
                                <Compare CompareOp="EQ">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="Entity1Id" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Const ConstValue="{guid'DBD23C1E-D89E-EB11-8147-0050569F2515'}" />
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Compare CompareOp="EQ">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="Entity1ObjectTypeCode" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Const ConstValue="(112)" />
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                            </Logical>
                          </ScalarOperator>
                          <ScalarOperator>
                            <Const ConstValue="NULL" />
                          </ScalarOperator>
                        </Logical>
                      </ScalarOperator>
                    </Predicate>
                  </IndexScan>
                </RelOp>
                <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="18523200">
                  <OutputList>
                    <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="ModifiedOn" />
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualRowsRead="1" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
                  </RunTimeInformation>
                  <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
                    <DefinedValues>
                      <DefinedValue>
                        <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="ModifiedOn" />
                      </DefinedValue>
                    </DefinedValues>
                    <Object Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Index="[cndx_PrimaryKey_BusinessProcessFlowInstance]" Alias="[businessprocessflowinstance0]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
                    <SeekPredicates>
                      <SeekPredicateNew>
                        <SeekKeys>
                          <Prefix ScanType="EQ">
                            <RangeColumns>
                              <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="BusinessProcessFlowInstanceId" />
                            </RangeColumns>
                            <RangeExpressions>
                              <ScalarOperator ScalarString="[sso_MSCRM].[dbo].[BusinessProcessFlowInstanceBase].[BusinessProcessFlowInstanceId] as [businessprocessflowinstance0].[BusinessProcessFlowInstanceId]">
                                <Identifier>
                                  <ColumnReference Database="[sso_MSCRM]" Schema="[dbo]" Table="[BusinessProcessFlowInstanceBase]" Alias="[businessprocessflowinstance0]" Column="BusinessProcessFlowInstanceId" />
                                </Identifier>
                              </ScalarOperator>
                            </RangeExpressions>
                          </Prefix>
                        </SeekKeys>
                      </SeekPredicateNew>
                    </SeekPredicates>
                  </IndexScan>
                </RelOp>
              </NestedLoops>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>