Problem:

SQL statement                                                           SQL 2000 (cost)                              SQL2012

1 customer select  SQL Statement ( little long)           22 seconds                                     5 mins (after rebuild index)

Migration method:

1. Backup SQL2000 DB and restore to SQL2008;

2. Backup SQL2008 DB and restore to SQL2012.

Anybody can help on this case? Thanks!

Environment
-----------
SQL2000 and SQL2005 instances: 4CPU, 4GB RAM, Windows Server 2000 SP4
SQL2012 R2: 4 vitual CPU cores, 8GB RAM, Windows Server 2012R2

• Edited by Yang_MS 1 hour 38 minutes ago

What is the compatibility level of the database that you have restored to SQL Server 2012?

Additionally, can you post few details such as:

1. Full query text along with execution plan

2. The index structure and size details of the tables involved in the query

3. The wait_type you are seeing while executing the query

Can you show us (if it is possible) execution plan before and after upgrading?

Please see this:

7 MISTAKES YOU CANT AFFORD TO MAKE WHEN UPGRADING TO SQL 2012

Thanks!

Answer to

1. Full query text along with execution plan

SELECT CRW.Channel,CRW.[Channel_Mapping], isnull(AB.Area_1,'') as [Area]  
,isnull(AB.Local_Channel,'') as [Customer_Local_Channel]  
,CRW.[Parent_Cust_Code] , CRW.[Parent_Cust_Name]  
,CRW.[Customer_Code] , CRW.[Customer_Name],[Rebate_Code]  
,CRW.[Rebate_Name],CRW.[Ship_To_Code],CRW.[Ship_To_Name],CRW.[Qtr_Target]  
,CRW.[New_Cust],CRW.[Last_2y_mth_avg],CRW.[Last_1y_mth_avg]  
,(  
select isnull(sum(quantity),0)  
from JDE_Download a  
left join jde_addressbook b  
on a.Customer_Code = b.Address_Number COLLATE Chinese_Taiwan_Stroke_CS_AS  
where b.F5th_Address_Number = CRW.[Parent_Cust_Code] COLLATE Chinese_Taiwan_Stroke_CS_AS  
and tw_local_category='30'  
and order_type not in('SJ','SG')  
and yearmonth like '2014%'  
 ) as [Jan_Target]  
,0 as [Feb_Target]  
,(  
select isnull(sum(quantity),0)  
from JDE_Download a  
left join jde_addressbook b  
on a.Customer_Code = b.Address_Number COLLATE Chinese_Taiwan_Stroke_CS_AS  
where b.F5th_Address_Number = CRW.[Parent_Cust_Code] COLLATE Chinese_Taiwan_Stroke_CS_AS  
and tw_local_category='30'  
and order_type not in('SJ','SG')  
and [General_Ledger_Date] BetWeen '2014/04/01' and '2014/04/17'  
 ) as [Mar_Target]  
,0 as [Apr_Target]  
,0 as [May_Target]  
,(  
select isnull(sum(quantity),0)  
from JDE_Download a  
where a.address_6 = CRW.[Parent_Cust_Code] COLLATE Chinese_Taiwan_Stroke_CS_AS  
AND tw_local_category = '30'  
AND Segment_3='R225'  
AND YearMonth in ('201503','201504')  
) as [Jun_Target]  
,(  
select isnull(sum(quantity),0)  
from JDE_Download a  
where a.address_6 = CRW.[Parent_Cust_Code] COLLATE Chinese_Taiwan_Stroke_CS_AS  
AND tw_local_category = '30'  
AND Segment_3<>'R225'  
AND YearMonth in ('201503','201504')  
) as [Jul_Target]  
,CRW.[Aug_Target],CRW.[Sep_Target]  
,CRW.[Oct_Target],CRW.[Nov_Target],CRW.[Dec_Target]  
,(  
select isnull(sum(quantity),0)  
from JDE_Download a  
left join jde_addressbook b  
on a.Customer_Code = b.Address_Number COLLATE Chinese_Taiwan_Stroke_CS_AS  
where b.F5th_Address_Number = CRW.[Parent_Cust_Code] COLLATE Chinese_Taiwan_Stroke_CS_AS  
and tw_local_category='30'  
and order_type not in('SJ','SG')  
and yearmonth like '2015%'  
 ) as [Sales_Total]  
,(  
select isnull(sum(quantity),0)  
from JDE_Download a  
left join jde_addressbook b  
on a.Customer_Code = b.Address_Number COLLATE Chinese_Taiwan_Stroke_CS_AS  
where b.F5th_Address_Number = CRW.[Parent_Cust_Code] COLLATE Chinese_Taiwan_Stroke_CS_AS  
and tw_local_category='30'  
and order_type not in('SJ','SG')  
and yearmonth in ('201501','201502','201503')  
 ) as [Sales_Q1]  
,(  
select isnull(sum(quantity),0)  
from JDE_Download a  
left join jde_addressbook b  
on a.Customer_Code = b.Address_Number COLLATE Chinese_Taiwan_Stroke_CS_AS  
where b.F5th_Address_Number = CRW.[Parent_Cust_Code] COLLATE Chinese_Taiwan_Stroke_CS_AS  
and tw_local_category='30'  
and order_type not in('SJ','SG')  
and yearmonth in ('201504','201505','201506')  
 ) as [Sales_Q2]  
,(  
select isnull(sum(quantity),0)  
from JDE_Download a  
left join jde_addressbook b  
on a.Customer_Code = b.Address_Number COLLATE Chinese_Taiwan_Stroke_CS_AS  
where b.F5th_Address_Number = CRW.[Parent_Cust_Code] COLLATE Chinese_Taiwan_Stroke_CS_AS  
and tw_local_category='30'  
and order_type not in('SJ','SG')  
and yearmonth in ('201507','201508','201509')  
 ) as [Sales_Q3]  
,(  
select isnull(sum(quantity),0)  
from JDE_Download a  
left join jde_addressbook b  
on a.Customer_Code = b.Address_Number COLLATE Chinese_Taiwan_Stroke_CS_AS  
where b.F5th_Address_Number = CRW.[Parent_Cust_Code] COLLATE Chinese_Taiwan_Stroke_CS_AS  
and tw_local_category='30'  
and order_type not in('SJ','SG')  
and yearmonth in ('201510','201511','201512')  
 ) as [Sales_Q4]  
,(  
select isnull(sum(quantity),0)  
from JDE_Download a  
left join jde_addressbook b  
on a.Customer_Code = b.Address_Number COLLATE Chinese_Taiwan_Stroke_CS_AS  
where b.F5th_Address_Number = CRW.[Parent_Cust_Code] COLLATE Chinese_Taiwan_Stroke_CS,1,1,0,NULL,NULL,1,NULL,497.7165,NULL,NULL,NULL,689.5999,NULL,NULL,SELECT,0,NULL

1.  execution plan

  |--Compute Scalar(DEFINE:([Expr1013]=isnull([Expr1011],(0.000000000000000e+000)), [Expr1014]=(0), [Expr1021]=isnull([Expr1019],(0.000000000000000e+000)), [Expr1022]=(0), [Expr1023]=(0), [Expr1028]=isnull([Expr1026],(0.000000000000000e+000)), [Expr1033]=isnull([Expr1031],(0.000000000000000e+000)), [Expr1040]=isnull([Expr1038],(0.000000000000000e+000)), [Expr1047]=isnull([Expr1045],(0.000000000000000e+000)), [Expr1054]=isnull([Expr1052],(0.000000000000000e+000)), [Expr1061]=isnull([Expr1059],(0.000000000000000e+000)), [Expr1068]=isnull([Expr1066],(0.000000000000000e+000)), [Expr1075]=isnull([Expr1073],(0.000000000000000e+000)), [Expr1082]=isnull([Expr1080],(0.000000000000000e+000)), [Expr1089]=isnull([Expr1087],(0.000000000000000e+000)), [Expr1096]=isnull([Expr1094],(0.000000000000000e+000)), [Expr1103]=isnull([Expr1101],(0.000000000000000e+000)), [Expr1110]=isnull([Expr1108],(0.000000000000000e+000)), [Expr1117]=isnull([Expr1115],(0.000000000000000e+000)), [Expr1124]=isnull([Expr1122],(0.000000000000000e+000)), [Expr1131]=isnull([Expr1129],(0.000000000000000e+000)), [Expr1138]=isnull([Expr1136],(0.000000000000000e+000)), [Expr1145]=isnull([Expr1143],(0.000000000000000e+000)), [Expr1152]=isnull([Expr1150],(0.000000000000000e+000)))),1,2,1,Compute Scalar,Compute Scalar,DEFINE:([Expr1013]=isnull([Expr1011],(0.000000000000000e+000)), [Expr1014]=(0), [Expr1021]=isnull([Expr1019],(0.000000000000000e+000)), [Expr1022]=(0), [Expr1023]=(0), [Expr1028]=isnull([Expr1026],(0.000000000000000e+000)), [Expr1033]=isnull([Expr1031],(0.000000000000000e+000)), [Expr1040]=isnull([Expr1038],(0.000000000000000e+000)), [Expr1047]=isnull([Expr1045],(0.000000000000000e+000)), [Expr1054]=isnull([Expr1052],(0.000000000000000e+000)), [Expr1061]=isnull([Expr1059],(0.000000000000000e+000)), [Expr1068]=isnull([Expr1066],(0.000000000000000e+000)), [Expr1075]=isnull([Expr1073],(0.000000000000000e+000)), [Expr1082]=isnull([Expr1080],(0.000000000000000e+000)), [Expr1089]=isnull([Expr1087],(0.000000000000000e+000)), [Expr1096]=isnull([Expr1094],(0.000000000000000e+000)), [Expr1103]=isnull([Expr1101],(0.000000000000000e+000)), [Expr1110]=isnull([Expr1108],(0.000000000000000e+000)), [Expr1117]=isnull([Expr1115],(0.000000000000000e+000)), [Expr1124]=isnull([Expr1122],(0.000000000000000e+000)), [Expr1131]=isnull([Expr1129],(0.000000000000000e+000)), [Expr1138]=isnull([Expr1136],(0.000000000000000e+000)), [Expr1145]=isnull([Expr1143],(0.000000000000000e+000)), [Expr1152]=isnull([Expr1150],(0.000000000000000e+000))),[Expr1013]=isnull([Expr1011],(0.000000000000000e+000)), [Expr1014]=(0), [Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1013], [Expr1014], [Expr1021], [Expr1022], [Expr1023], [Expr1028], [Expr1033], [Expr1040], [Expr1047], [Expr1054], [Expr1061], [Expr1068], [Expr1075], [Expr1082], [Expr1089], [Expr1096], [Expr1103], [Expr1110], [Expr1117], [Expr1124], [Expr1131], [Expr1138], [Expr1145], [Expr1152],NULL,PLAN_ROW,0,1
       |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,3,2,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1899,689.5999,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073], [Expr1080], [Expr1087], [Expr1094], [Expr1101], [Expr1108], [Expr1115], [Expr1122], [Expr1129], [Expr1136], [Expr1143], [Expr1150],NULL,PLAN_ROW,0,1
            |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,4,3,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1891,689.2623,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073], [Expr1080], [Expr1087], [Expr1094], [Expr1101], [Expr1108], [Expr1115], [Expr1122], [Expr1129], [Expr1136], [Expr1143],NULL,PLAN_ROW,0,1
            |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,5,4,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1883,688.9249,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073], [Expr1080], [Expr1087], [Expr1094], [Expr1101], [Expr1108], [Expr1115], [Expr1122], [Expr1129], [Expr1136],NULL,PLAN_ROW,0,1
            |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,6,5,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1875,688.5874,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073], [Expr1080], [Expr1087], [Expr1094], [Expr1101], [Expr1108], [Expr1115], [Expr1122], [Expr1129],NULL,PLAN_ROW,0,1
            |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,7,6,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1866,688.2499,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073], [Expr1080], [Expr1087], [Expr1094], [Expr1101], [Expr1108], [Expr1115], [Expr1122],NULL,PLAN_ROW,0,1
            |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,8,7,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1858,687.9124,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073], [Expr1080], [Expr1087], [Expr1094], [Expr1101], [Expr1108], [Expr1115],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,9,8,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1850,687.575,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073], [Expr1080], [Expr1087], [Expr1094], [Expr1101], [Expr1108],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,10,9,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1842,687.2375,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073], [Expr1080], [Expr1087], [Expr1094], [Expr1101],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,11,10,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1834,686.9,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073], [Expr1080], [Expr1087], [Expr1094],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,12,11,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1826,670.2579,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073], [Expr1080], [Expr1087],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,13,12,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1818,661.1638,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073], [Expr1080],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,14,13,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1810,648.2534,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066], [Expr1073],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,15,14,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1801,638.7095,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059], [Expr1066],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,16,15,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1793,638.372,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052], [Expr1059],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,17,16,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1785,638.0345,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045], [Expr1052],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,18,17,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1777,627.3322,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038], [Expr1045],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,19,18,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1769,616.6299,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031], [Expr1038],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,20,19,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1761,605.9097,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026], [Expr1031],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,21,20,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1753,281.6566,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019], [Expr1026],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,22,21,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1745,18.4746,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011], [Expr1019],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([CRW].[Parent_Cust_Code])),1,23,22,Nested Loops,Inner Join,OUTER REFERENCES:([CRW].[Parent_Cust_Code]),NULL,497.7165,0,0.002080455,1736,14.40793,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006], [Expr1011],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |--Compute Scalar(DEFINE:([Expr1005]=isnull([JDE_TEST].[dbo].[JDE_addressbook].[Area_1] as [AB].[Area_1],N''), [Expr1006]=isnull([JDE_TEST].[dbo].[JDE_addressbook].[Local_Channel] as [AB].[Local_Channel],N''))),1,24,23,Compute Scalar,Compute Scalar,DEFINE:([Expr1005]=isnull([JDE_TEST].[dbo].[JDE_addressbook].[Area_1] as [AB].[Area_1],N''), [Expr1006]=isnull([JDE_TEST].[dbo].[JDE_addressbook].[Local_Channel] as [AB].[Local_Channel],N'')),[Expr1005]=isnull([JDE_TEST].[dbo].[JDE_addressbook].[Area_1] as [AB].[Area_1],N''), [Expr1006]=isnull([JDE_TEST].[dbo].[JDE_addressbook].[Local_Channel] as [AB].[Local_Channel],N''),497.7165,0,4.977165E-05,1728,0.453685,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1], [Expr1005], [Expr1006],NULL,PLAN_ROW,0,1
            |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |    |--Sort(ORDER BY:([AB].[Area_1] ASC, [AB].[Local_Channel] ASC, [CRW].[Parent_Cust_Code] ASC)),1,25,24,Sort,Sort,ORDER BY:([AB].[Area_1] ASC, [AB].[Local_Channel] ASC, [CRW].[Parent_Cust_Code] ASC),NULL,497.7165,0.01126126,0.00705794,1694,0.4536353,[CRW].[Channel], [CRW].[Channel_Mapping], [CRW].[Parent_Cust_Code], [CRW].[Parent_Cust_Name], [CRW].[Customer_Code], [CRW].[Customer_Name], [CRW].[Rebate_Code], [CRW].[Rebate_Name], [CRW].[Ship_To_Code], [CRW].[Ship_To_Name], [CRW].[Qtr_Target], [CRW].[New_Cust], [CRW].[Last_2y_mth_avg], [CRW].[Last_1y_mth_avg], [CRW].[Aug_Target], [CRW].[Sep_Target], [CRW].[Oct_Target], [CRW].[Nov_Target], [CRW].[Dec_Target], [CRW].[Sales_Forecast], [CRW].[RetreadFlag], [CRW].[Last_2y_mth_avg_RD], [CRW].[Last_1y_mth_avg_RD], [CRW].[], [CRW].[Memo], [CRW].[OE_Short_Name], [CRW].[Item_Type], [AB].[Local_Channel], [AB].[Area_1],NULL,PLAN_ROW,0,1