SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Huge Table
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ahmeds08
Aged Yak Warrior

India
625 Posts

Posted - 06/11/2013 :  12:16:45  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
Dear Experts,
Need your advice on the below.

I have a table with around 100 million records and it is properly indexed.
The queries which are using this table are consuming huge CPU.
So,what are the possible ways I can tune this table.

we are on standard edition,so partitioning is not an option for me.

please help

mohammad.javeed.ahmed@gmail.com

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 06/11/2013 :  14:29:50  Show Profile  Visit russell's Homepage  Reply with Quote
Sounds like it is NOT properly indexed for these queries.

You'll need to examine the execution plan of the queries hogging up CPU.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2047 Posts

Posted - 06/11/2013 :  14:58:40  Show Profile  Visit jackv's Homepage  Reply with Quote
Can you post the execution plan?
Typically , but not exclusively, high CPU is a result of : Hash Joins, Sorts, Filters.
Some guidance on tuning a slow running query - http://www.sqlserver-dba.com/2012/11/sql-server-how-to-troubleshoot-a-slow-running-query.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

ahmeds08
Aged Yak Warrior

India
625 Posts

Posted - 06/12/2013 :  05:09:10  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
Here is the query consuming huge cpu,as per the standard report the average CPU for this query is 933,165.08

SELECT
INCOMING.BUSINESSDATE,
INCOMING.DETAILKEY,
INCOMING.TICKETID,
INCOMING.DEPTID,
INCOMING.ITEMTYPE,
INCOMING.DESCRIPTION,
INCOMING.PRICE,
INCOMING.TAXTYPE,
INCOMING.TAXRATE,
INCOMING.ENTRYTIME,
INCOMING.ORDERTYPE,
INCOMING.PRINTED,
INCOMING.PRINTERGROUP,
INCOMING.ACCOUNT,
INCOMING.ITEMID,
INCOMING.COSTPRICE,
INCOMING.GUESTCOUNT,
INCOMING.APPROVEDBY,
INCOMING.ENTEREDBY,
INCOMING.DISCOUNTID,
INCOMING.MENUID
FROM POSTICKETDETAIL.DBO.TBLTICKETDETAILARCHIVE INCOMING
LEFT OUTER JOIN
POSTICKETDETAILARCHIVE.DBO.TBLTICKETDETAILARCHIVE ARCHIVE
ON
INCOMING.BUSINESSDATE = ARCHIVE.BUSINESSDATE
AND CAST(INCOMING.DEPTID AS INT) = CAST(ARCHIVE.DEPTID AS INT)
AND INCOMING.DETAILKEY = ARCHIVE.DETAILKEY
AND INCOMING.TICKETID = ARCHIVE.TICKETID
WHERE
ARCHIVE.BUSINESSDATE IS NULL
AND ARCHIVE.DEPTID IS NULL
AND ARCHIVE.DETAILKEY IS NULL
AND ARCHIVE.TICKETID IS NULL

Below is the execution plan.
<?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.1" Build="10.50.1746.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="31056200" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="4726.15" StatementText="SELECT #xD;#xA; INCOMING.BUSINESSDATE, #xD;#xA; INCOMING.DETAILKEY, #xD;#xA; INCOMING.TICKETID, #xD;#xA; INCOMING.DEPTID, #xD;#xA; INCOMING.ITEMTYPE, #xD;#xA; INCOMING.DESCRIPTION, #xD;#xA; INCOMING.PRICE, #xD;#xA; INCOMING.TAXTYPE, #xD;#xA; INCOMING.TAXRATE, #xD;#xA; INCOMING.ENTRYTIME, #xD;#xA; INCOMING.ORDERTYPE, #xD;#xA; INCOMING.PRINTED, #xD;#xA; INCOMING.PRINTERGROUP, #xD;#xA; INCOMING.ACCOUNT, #xD;#xA; INCOMING.ITEMID, #xD;#xA; INCOMING.COSTPRICE, #xD;#xA; INCOMING.GUESTCOUNT, #xD;#xA; INCOMING.APPROVEDBY, #xD;#xA; INCOMING.ENTEREDBY, #xD;#xA; INCOMING.DISCOUNTID, #xD;#xA; INCOMING.MENUID#xD;#xA;FROM POSTICKETDETAIL.DBO.TBLTICKETDETAILARCHIVE INCOMING#xD;#xA;LEFT OUTER JOIN #xD;#xA; POSTICKETDETAILARCHIVE.DBO.TBLTICKETDETAILARCHIVE ARCHIVE#xD;#xA;ON #xD;#xA; INCOMING.BUSINESSDATE = ARCHIVE.BUSINESSDATE#xD;#xA; AND CAST(INCOMING.DEPTID AS INT) = CAST(ARCHIVE.DEPTID AS INT)#xD;#xA; AND INCOMING.DETAILKEY = ARCHIVE.DETAILKEY#xD;#xA; AND INCOMING.TICKETID = ARCHIVE.TICKETID#xD;#xA;WHERE #xD;#xA; ARCHIVE.BUSINESSDATE IS NULL#xD;#xA; AND ARCHIVE.DEPTID IS NULL#xD;#xA; AND ARCHIVE.DETAILKEY IS NULL#xD;#xA; AND ARCHIVE.TICKETID IS NULL#xD;#xA;" StatementType="SELECT" QueryHash="0xB7B7D919EBCCB528" QueryPlanHash="0x72A9E41D08978A28">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan CachedPlanSize="96" CompileTime="104" CompileCPU="34" CompileMemory="1080">
<RelOp AvgRowSize="260" EstimateCPU="148.655" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="31056200" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="4726.15">
<OutputList>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="BUSINESSDATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TICKETID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DEPTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DESCRIPTION" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRICE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXRATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTRYTIME" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ORDERTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTED" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTERGROUP" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ACCOUNT" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="CostPrice" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="GuestCount" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ApprovedBy" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTEREDBY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DISCOUNTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="MENUID" />
</OutputList>
<Parallelism>
<RelOp AvgRowSize="260" EstimateCPU="7.66052" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="31056200" LogicalOp="Filter" NodeId="1" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="4577.5">
<OutputList>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="BUSINESSDATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TICKETID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DEPTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DESCRIPTION" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRICE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXRATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTRYTIME" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ORDERTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTED" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTERGROUP" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ACCOUNT" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="CostPrice" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="GuestCount" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ApprovedBy" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTEREDBY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DISCOUNTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="MENUID" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="284" EstimateCPU="1060.05" EstimateIO="2017.5" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="31056200" LogicalOp="Right Outer Join" NodeId="2" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="4569.83">
<OutputList>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="BUSINESSDATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TICKETID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DEPTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DESCRIPTION" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRICE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXRATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTRYTIME" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ORDERTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTED" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTERGROUP" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ACCOUNT" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="CostPrice" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="GuestCount" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ApprovedBy" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTEREDBY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DISCOUNTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="MENUID" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="BUSINESSDATE" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="TICKETID" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DEPTID" />
</OutputList>
<MemoryFractions Input="1" Output="1" />
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="BUSINESSDATE" />
<ColumnReference Column="Expr1005" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="TICKETID" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="BUSINESSDATE" />
<ColumnReference Column="Expr1004" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TICKETID" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[POSTicketDetail].[dbo].[tblTicketDetailArchive].[BUSINESSDATE] as [INCOMING].[BUSINESSDATE]=[POSTicketDetailArchive].[dbo].[tblTicketDetailArchive].[BUSINESSDATE] as [ARCHIVE].[BUSINESSDATE] AND [Expr1004]=[Expr1005] AND [POSTicketDetail].[dbo].[tblTicketDetailArchive].[DETAILKEY] as [INCOMING].[DETAILKEY]=[POSTicketDetailArchive].[dbo].[tblTicketDetailArchive].[DETAILKEY] as [ARCHIVE].[DETAILKEY] AND [POSTicketDetail].[dbo].[tblTicketDetailArchive].[TICKETID] as [INCOMING].[TICKETID]=[POSTicketDetailArchive].[dbo].[tblTicketDetailArchive].[TICKETID] as [ARCHIVE].[TICKETID]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="BUSINESSDATE" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="BUSINESSDATE" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1004" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1005" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DETAILKEY" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DETAILKEY" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TICKETID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="TICKETID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="36" EstimateCPU="202.855" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="173783000" LogicalOp="Repartition Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="688.39">
<OutputList>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="BUSINESSDATE" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="TICKETID" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DEPTID" />
<ColumnReference Column="Expr1005" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="BUSINESSDATE" />
<ColumnReference Column="Expr1005" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="TICKETID" />
</PartitionColumns>
<RelOp AvgRowSize="36" EstimateCPU="2.89639" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="173783000" LogicalOp="Compute Scalar" NodeId="4" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="485.535">
<OutputList>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="BUSINESSDATE" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="TICKETID" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DEPTID" />
<ColumnReference Column="Expr1005" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1005" />
<ScalarOperator ScalarString="CONVERT(int,[POSTicketDetailArchive].[dbo].[tblTicketDetailArchive].[DEPTID] as [ARCHIVE].[DEPTID],0)">
<Convert DataType="int" Style="0" Implicit="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DEPTID" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="32" EstimateCPU="31.8603" EstimateIO="450.778" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="173783000" LogicalOp="Index Scan" NodeId="5" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="482.638" TableCardinality="173783000">
<OutputList>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="BUSINESSDATE" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="TICKETID" />
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DEPTID" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="BUSINESSDATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DETAILKEY" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="TICKETID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DEPTID" />
</DefinedValue>
</DefinedValues>
<Object Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Index="[FK_tblTicketDetailArchive_tblDayClosings]" Alias="[ARCHIVE]" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="264" EstimateCPU="160.204" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="31056200" LogicalOp="Repartition Streams" NodeId="9" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="803.893">
<OutputList>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="BUSINESSDATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TICKETID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DEPTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DESCRIPTION" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRICE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXRATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTRYTIME" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ORDERTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTED" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTERGROUP" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ACCOUNT" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="CostPrice" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="GuestCount" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ApprovedBy" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTEREDBY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DISCOUNTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="MENUID" />
<ColumnReference Column="Expr1004" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="BUSINESSDATE" />
<ColumnReference Column="Expr1004" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TICKETID" />
</PartitionColumns>
<RelOp AvgRowSize="264" EstimateCPU="0.517603" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="31056200" LogicalOp="Compute Scalar" NodeId="10" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="643.688">
<OutputList>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="BUSINESSDATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TICKETID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DEPTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DESCRIPTION" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRICE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXRATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTRYTIME" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ORDERTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTED" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTERGROUP" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ACCOUNT" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="CostPrice" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="GuestCount" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ApprovedBy" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTEREDBY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DISCOUNTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="MENUID" />
<ColumnReference Column="Expr1004" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1004" />
<ScalarOperator ScalarString="CONVERT(int,[POSTicketDetail].[dbo].[tblTicketDetailArchive].[DEPTID] as [INCOMING].[DEPTID],0)">
<Convert DataType="int" Style="0" Implicit="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DEPTID" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="260" EstimateCPU="5.69365" EstimateIO="637.477" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="31056200" LogicalOp="Clustered Index Scan" NodeId="11" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="643.171" TableCardinality="31056200">
<OutputList>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="BUSINESSDATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DETAILKEY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TICKETID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DEPTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DESCRIPTION" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRICE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXRATE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTRYTIME" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ORDERTYPE" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTED" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTERGROUP" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ACCOUNT" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="CostPrice" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="GuestCount" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ApprovedBy" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTEREDBY" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DISCOUNTID" />
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="MENUID" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="BUSINESSDATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DETAILKEY" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TICKETID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DEPTID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMTYPE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DESCRIPTION" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRICE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXTYPE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="TAXRATE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTRYTIME" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ORDERTYPE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTED" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="PRINTERGROUP" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ACCOUNT" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ITEMID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="CostPrice" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="GuestCount" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ApprovedBy" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="ENTEREDBY" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="DISCOUNTID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[INCOMING]" Column="MENUID" />
</DefinedValue>
</DefinedValues>
<Object Database="[POSTicketDetail]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Index="[PK_tblTicketDetailArchive]" Alias="[INCOMING]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[POSTicketDetailArchive].[dbo].[tblTicketDetailArchive].[BUSINESSDATE] as [ARCHIVE].[BUSINESSDATE] IS NULL AND [POSTicketDetailArchive].[dbo].[tblTicketDetailArchive].[DEPTID] as [ARCHIVE].[DEPTID] IS NULL AND [POSTicketDetailArchive].[dbo].[tblTicketDetailArchive].[DETAILKEY] as [ARCHIVE].[DETAILKEY] IS NULL AND [POSTicketDetailArchive].[dbo].[tblTicketDetailArchive].[TICKETID] as [ARCHIVE].[TICKETID] IS NULL">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="BUSINESSDATE" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DEPTID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="DETAILKEY" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[POSTicketDetailArchive]" Schema="[dbo]" Table="[tblTicketDetailArchive]" Alias="[ARCHIVE]" Column="TICKETID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Parallelism>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>

mohammad.javeed.ahmed@gmail.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 1.94 seconds. Powered By: Snitz Forums 2000