performance tuning - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

performance tuning

Author

Topic

rajyalakshmi
Starting Member

16 Posts

Posted - 2007-03-14 : 04:24:30

Hi experts,
I am using sqlprofiler for performance tuning.I have got %processor =51 for long time continuously.please give the dbcc commands or any sql queries to tune the cpu.

thanks in advance

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-14 : 04:39:14

There is no command to tune the CPU.

You will have to check:

1. Whether there any other applications running on the box that is doing any CPU intensive operation
2. Whether any background jobs are running
3. Normally queries should not cause CPU time to increase (unless you are doing complex calculations inside them which your query doesn't seem to do)

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2007-03-14 : 04:43:16

You are repeating these questions WITHOUT supplying the key info....as IDENTIFIED earlier in other posts. (Multiple posts won't get a problem solved faster)

There is NO quick fix for this sort of problem. There may indeed be NO fix at all for the problem, without upgrading your hardware/database. DBCC commands on their own won't tune the CPU....and neither will SQL Queries.

Please (Post Here) DDL + EXECUTION PLANS and MAYBE we can offer advice. Most of the solution will however have to come from yourself.....by experimenting to track down th problem item!!!
Find a query/configuration that works (a.k.a doesn't cause a problem) and then compare against the problem situation.....1-by-1 eliminate the differences, TEST and measure the output/performance and then understand/actup the true causes of the problem.

It WON'T be easy....but it'll be far easier for you, local to the problem, than it will for us 6/7000 miles away working with 2 lines of a problem description!

Kristen
Test

22859 Posts

Posted - 2007-03-14 : 05:00:19

Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80512

rajyalakshmi
Starting Member

16 Posts

Posted - 2007-03-14 : 05:28:48

my query is --
SELECT COMPANY_ID,COMPANY_NAME,COMPANY_ID BRANCH_ID,COMPANY_NAME BRANCH_NAME,UNIQ_ID,DOCUMENT_TYPE,TRANS_ID, DOCUMENT_NO,DOCUMENT_DATE,SNO,POSTING_DATE,ACCOUNT_ID,ACCOUNT_NAME,ACCOUNT_CODE, DEBIT_AMOUNT,CREDIT_AMOUNT,NARRATION,REMARKS FROM VRPT_FIN_GL_ACCOUNTSDATA WHERE POSTING_DATE Between CONVERT(CHAR(10),'03/01/2006',120) and CONVERT(CHAR(10),'03/14/2007',120) And COMPANY_ID = '03E347F0-410C-4AD2-8151-5EB88EAB0FB9'

UNION ALL

SELECT COMPANY_ID,COMPANY_NAME,COMPANY_ID BRANCH_ID,COMPANY_NAME BRANCH_NAME,UNIQ_ID,DOCUMENT_TYPE,TRANS_ID, DOCUMENT_NO,DOCUMENT_DATE,SNO,POSTING_DATE,ACCOUNT_ID,ACCOUNT_NAME,ACCOUNT_CODE, SUM(DEBIT_AMOUNT),SUM(CREDIT_AMOUNT),NARRATION,REMARKS FROM VRPT_FIN_GL_ACCOUNTSOPEN WHERE POSTING_DATE1<'2006/3/1' AND COMPANY_ID In ('03E347F0-410C-4AD2-8151-5EB88EAB0FB9') GROUP BY COMPANY_ID,COMPANY_NAME,UNIQ_ID,DOCUMENT_TYPE,TRANS_ID,DOCUMENT_NO,DOCUMENT_DATE,SNO,POSTING_DATE,ACCOUNT_ID,ACCOUNT_NAME,ACCOUNT_CODE,NARRATION,REMARKS

execution plan is -----

SELECT COMPANY_ID,COMPANY_NAME,COMPANY_ID BRANCH_ID,COMPANY_NAME BRANCH_NAME,UNIQ_ID,DOCUMENT_TYPE,TRANS_ID, DOCUMENT_NO,DOCUMENT_DATE,SNO,POSTING_DATE,ACCOUNT_ID,ACCOUNT_NAME,ACCOUNT_CODE, DEBIT_AMOUNT,CREDIT_AMOUNT,NARRATION,REMARKS FROM VRPT_FIN_GL_ACC 6 1 0 NULL NULL 1 NULL 4.0976164E+7 NULL NULL NULL 2037.5935 NULL NULL SELECT 0 NULL
|--Concatenation 6 2 1 Concatenation Concatenation NULL [Union1367] = ([GATABLE028].[COLUMN001], [GATABLE028].[COLUMN001]), [Union1368] = ([GATABLE028].[COLUMN009], [GATABLE028].[COLUMN009]), [Union1369] = ([GATABLE028].[COLUMN001], [GATABLE028].[COLUMN001]), [Union1370] = ([GATABLE028].[COLUMN009], [GATABLE028 4.0976164E+7 0.0 4.0976162 2171 2037.5935 [Union1367], [Union1368], [Union1369], [Union1370], [Union1371], [Union1372], [Union1373], [Union1374], [Union1375], [Union1376], [Union1377], [Union1378], [Union1379], [Union1380], [Union1381], [Union1382], [Union1383], [Union1384] NULL PLAN_ROW 0 1.0
|--Compute Scalar(DEFINE:([GATABLE028].[COLUMN001]=[GATABLE028].[COLUMN001], [GATABLE028].[COLUMN009]=[GATABLE028].[COLUMN009])) 6 3 2 Compute Scalar Compute Scalar DEFINE:([GATABLE028].[COLUMN001]=[GATABLE028].[COLUMN001], [GATABLE028].[COLUMN009]=[GATABLE028].[COLUMN009]) [GATABLE028].[COLUMN001]=[GATABLE028].[COLUMN001], [GATABLE028].[COLUMN009]=[GATABLE028].[COLUMN009] 4.0976052E+7 0.0 4.0976052 2171 2029.1698 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Union1070], [Union1072], [Union1073], [Union1074], [Union1076], [Union1077], [Union1090], [Union1091], [Union1112], [Union1113], [Expr1165], [Expr1179], [Expr1180], [Expr1181], [GATABLE028].[COLUMN001], NULL PLAN_ROW 0 1.0
| |--Compute Scalar(DEFINE:([Expr1179]=Convert([Union1075]), [Expr1180]=Convert([Union1083]), [Expr1181]=Convert([Union1084]))) 6 4 3 Compute Scalar Compute Scalar DEFINE:([Expr1179]=Convert([Union1075]), [Expr1180]=Convert([Union1083]), [Expr1181]=Convert([Union1084])) [Expr1179]=Convert([Union1075]), [Expr1180]=Convert([Union1083]), [Expr1181]=Convert([Union1084]) 4.0976052E+7 0.0 4.0976052 1991 2025.0721 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Union1070], [Union1072], [Union1073], [Union1074], [Union1076], [Union1077], [Union1090], [Union1091], [Union1112], [Union1113], [Expr1165], [Expr1179], [Expr1180], [Expr1181] NULL PLAN_ROW 0 1.0
| |--Compute Scalar(DEFINE:([Expr1165]=If (isnull([Union1164], 'Jan 1 1900 12:00AM')='Jan 1 1900 12:00AM') then [Union1076] else [Union1164])) 6 5 4 Compute Scalar Compute Scalar DEFINE:([Expr1165]=If (isnull([Union1164], 'Jan 1 1900 12:00AM')='Jan 1 1900 12:00AM') then [Union1076] else [Union1164]) [Expr1165]=If (isnull([Union1164], 'Jan 1 1900 12:00AM')='Jan 1 1900 12:00AM') then [Union1076] else [Union1164] 4.0976052E+7 0.0 4.0976052 1987 2020.9746 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Union1070], [Union1072], [Union1073], [Union1074], [Union1075], [Union1076], [Union1077], [Union1083], [Union1084], [Union1090], [Union1091], [Union1112], [Union1113], [Expr1165] NULL PLAN_ROW 0 1.0
| |--Nested Loops(Left Outer Join, WHERE:(If ([Expr1168]<>NULL) then [Expr1168] else [Expr1173]=0)OUTER REFERENCES:([Union1088])) 6 6 5 Nested Loops Left Outer Join WHERE:(If ([Expr1168]<>NULL) then [Expr1168] else [Expr1173]=0)OUTER REFERENCES:([Union1088]) NULL 4.0976052E+7 0.0 171.27989 2048 2016.877 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Union1070], [Union1072], [Union1073], [Union1074], [Union1075], [Union1076], [Union1077], [Union1083], [Union1084], [Union1090], [Union1091], [Union1112], [Union1113], [Union1164] NULL PLAN_ROW 0 1.0
| |--Nested Loops(Inner Join, WHERE:([Expr1168]<>NULL)OUTER REFERENCES:([Union1088])) 6 7 6 Nested Loops Inner Join WHERE:([Expr1168]<>NULL)OUTER REFERENCES:([Union1088]) NULL 4.0976052E+7 0.0 171.27989 2048 1514.3435 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Union1070], [Union1072], [Union1073], [Union1074], [Union1075], [Union1076], [Union1077], [Union1083], [Union1084], [Union1088], [Union1090], [Union1091], [Union1112], [Union1113], [Union1164], [Expr1168 NULL PLAN_ROW 0 1.0
| | |--Nested Loops(Inner Join, OUTER REFERENCES:([Union1088])) 6 8 7 Nested Loops Inner Join OUTER REFERENCES:([Union1088]) NULL 4.0976052E+7 0.0 171.27989 2044 917.65924 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Union1070], [Union1072], [Union1073], [Union1074], [Union1075], [Union1076], [Union1077], [Union1083], [Union1084], [Union1088], [Union1090], [Union1091], [Union1112], [Union1113], [Union1164], [Expr1168 NULL PLAN_ROW 0 1.0
| | | |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Union1073])) 6 10 8 Nested Loops Left Outer Join OUTER REFERENCES:([Union1073]) NULL 4.0976052E+7 0.0 167.18982 4411 329.1702 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Union1070], [Union1072], [Union1073], [Union1074], [Union1075], [Union1076], [Union1077], [Union1083], [Union1084], [Union1088], [Union1090], [Union1091], [Union1112], [Union1113], [Union1164] NULL PLAN_ROW 0 1.0
| | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([Union1077])) 6 11 10 Nested Loops Inner Join OUTER REFERENCES:([Union1077]) NULL 37291.637 0.0 0.23921748 4376 18.500717 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Union1070], [Union1072], [Union1073], [Union1074], [Union1075], [Union1076], [Union1077], [Union1083], [Union1084], [Union1088], [Union1090], [Union1091], [Union1112], [Union1113] NULL PLAN_ROW 0 1.0
| | | | | |--Nested Loops(Inner Join) 6 12 11 Nested Loops Inner Join NULL NULL 25975.924 0.0 0.10857937 4072 6.2998242 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Union1070], [Union1072], [Union1073], [Union1074], [Union1075], [Union1076], [Union1077], [Union1083], [Union1084], [Union1088], [Union1090], [Union1091] NULL PLAN_ROW 0 1.0
| | | | | | |--Nested Loops(Left Outer Join, OUTER REFERENCES:([GATABLE028].[COLUMN001])) 6 13 12 Nested Loops Left Outer Join OUTER REFERENCES:([GATABLE028].[COLUMN001]) NULL 1.0 0.0 4.1799999E-6 2532 4.4841822E-2 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
| | | | | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028]), SEEK:([GATABLE028].[COLUMN001]='03E347F0-410C-4AD2-8151-5EB88EAB0FB9') ORDERED FORWARD) 6 14 13 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028]), SEEK:([GATABLE028].[COLUMN001]='03E347F0-410C-4AD2-8151-5EB88EAB0FB9') ORDERED FORWARD [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001] 1.0 6.3284999E-3 7.9603E-5 2532 6.4081028E-3 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
| | | | | | | |--Top(1) 6 15 13 Top Top NULL NULL 1.0 0.0 0.0000001 4 0.03842954 NULL NULL PLAN_ROW 0 1.0
| | | | | | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE049].[PK_GATABLE049]), WHERE:([GATABLE049].[COLUMN002]=[GATABLE028].[COLUMN001])) 6 17 15 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE049].[PK_GATABLE049]), WHERE:([GATABLE049].[COLUMN002]=[GATABLE028].[COLUMN001]) [GATABLE049].[COLUMN002] 1.0 1.9159621E-2 5.0250001E-5 1276 3.8419742E-2 [GATABLE049].[COLUMN002] NULL PLAN_ROW 0 1.0
| | | | | | |--Sort(ORDER BY:([Union1088] ASC)) 6 19 12 Sort Sort ORDER BY:([Union1088] ASC) NULL 25975.924 1.1261261E-2 1.7485887 1548 6.1464028 [Union1070], [Union1072], [Union1073], [Union1074], [Union1075], [Union1076], [Union1077], [Union1083], [Union1084], [Union1088], [Union1090], [Union1091] NULL PLAN_ROW 0 1.0
| | | | | | |--Hash Match(Inner Join, HASH:([GATABLE028].[COLUMN001])=([Union1071]), RESIDUAL:([GATABLE028].[COLUMN001]=[Union1071])) 6 20 19 Hash Match Inner Join HASH:([GATABLE028].[COLUMN001])=([Union1071]), RESIDUAL:([GATABLE028].[COLUMN001]=[Union1071]) NULL 25975.924 0.0 0.25852585 1613 4.3865528 [Union1070], [Union1072], [Union1073], [Union1074], [Union1075], [Union1076], [Union1077], [Union1083], [Union1084], [Union1088], [Union1090], [Union1091] NULL PLAN_ROW 0 1.0
| | | | | | |--Nested Loops(Left Outer Join, OUTER REFERENCES:([GATABLE028].[COLUMN001])) 6 21 20 Nested Loops Left Outer Join OUTER REFERENCES:([GATABLE028].[COLUMN001]) NULL 18.181818 0.0 7.5999997E-5 2475 7.9570778E-2 [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
| | | | | | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028]), WHERE:([GATABLE028].[COLUMN030]='03E347F0-410C-4AD2-8151-5EB88EAB0FB9') ORDERED FORWARD) 6 22 21 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028]), WHERE:([GATABLE028].[COLUMN030]='03E347F0-410C-4AD2-8151-5EB88EAB0FB9') ORDERED FORWARD [GATABLE028].[COLUMN030], [GATABLE028].[COLUMN001] 18.181818 3.9059982E-2 0.0001005 2475 3.9160483E-2 [GATABLE028].[COLUMN030], [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
| | | | | | | |--Top(1) 6 23 21 Top Top NULL NULL 1.0 0.0 0.0000001 4 4.0324695E-2 NULL NULL PLAN_ROW 0 18.181818
| | | | | | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE049].[PK_GATABLE049]), WHERE:([GATABLE049].[COLUMN002]=[GATABLE028].[COLUMN001])) 6 25 23 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE049].[PK_GATABLE049]), WHERE:([GATABLE049].[COLUMN002]=[GATABLE028].[COLUMN001]) [GATABLE049].[COLUMN002] 1.0 3.8319241E-2 0.0001005 1263 4.0146515E-2 [GATABLE049].[COLUMN002] NULL PLAN_ROW 0 18.181818
| | | | | | |--Concatenation 6 27 20 Concatenation Concatenation NULL [Union1070] = ([OATABLE044].[COLUMN001], [OATABLE064].[COLUMN001], [OATABLE065].[COLUMN001]), [Union1071] = ([OATABLE044].[COLUMN010], [OATABLE064].[COLUMN002], [OATABLE065].[COLUMN002]), [Union1072] = ([OATABLE044].[COLUMN004], [Expr1027], [Expr1065]), [U 31225.109 0.0 3.1225111E-3 1575 4.0484533 [Union1070], [Union1071], [Union1072], [Union1073], [Union1074], [Union1075], [Union1076], [Union1077], [Union1083], [Union1084], [Union1088], [Union1090], [Union1091] NULL PLAN_ROW 0 1.0
| | | | | | |--Compute Scalar(DEFINE:([OATABLE044].[COLUMN001]=[OATABLE044].[COLUMN001], [OATABLE044].[COLUMN007]=[OATABLE044].[COLUMN007], [OATABLE044].[COLUMN008]=[OATABLE044].[COLUMN008])) 6 28 27 Compute Scalar Compute Scalar DEFINE:([OATABLE044].[COLUMN001]=[OATABLE044].[COLUMN001], [OATABLE044].[COLUMN007]=[OATABLE044].[COLUMN007], [OATABLE044].[COLUMN008]=[OATABLE044].[COLUMN008]) [OATABLE044].[COLUMN001]=[OATABLE044].[COLUMN001], [OATABLE044].[COLUMN007]=[OATABLE044].[COLUMN007], [OATABLE044].[COLUMN008]=[OATABLE044].[COLUMN008] 4.0 0.0 0.0000004 1562 3.7665721E-2 [OATABLE044].[COLUMN006], [OATABLE044].[COLUMN011], [OATABLE044].[COLUMN002], [OATABLE044].[COLUMN004], [OATABLE044].[COLUMN010], [OATABLE044].[COLUMN001], [Expr1014], [Expr1021], [Expr1023], [Expr1024], [OATABLE044].[COLUMN001], [OATABLE044].[COLUMN007], NULL PLAN_ROW 0 1.0
| | | | | | | |--Compute Scalar(DEFINE:([Expr1014]=Convert([OATABLE044].[COLUMN003]), [Expr1024]=Convert([OATABLE044].[COLUMN013]))) 6 29 28 Compute Scalar Compute Scalar DEFINE:([Expr1014]=Convert([OATABLE044].[COLUMN003]), [Expr1024]=Convert([OATABLE044].[COLUMN013])) [Expr1014]=Convert([OATABLE044].[COLUMN003]), [Expr1024]=Convert([OATABLE044].[COLUMN013]) 4.0 0.0 0.0000004 1535 3.7665319E-2 [OATABLE044].[COLUMN008], [OATABLE044].[COLUMN007], [OATABLE044].[COLUMN006], [OATABLE044].[COLUMN011], [OATABLE044].[COLUMN002], [OATABLE044].[COLUMN004], [OATABLE044].[COLUMN010], [OATABLE044].[COLUMN001], [Expr1014], [Expr1021], [Expr1023], [Expr1024] NULL PLAN_ROW 0 1.0
| | | | | | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE044].[PK_OATABLE044]), WHERE:([OATABLE044].[COLUMN011]>='Mar 1 2006 12:00AM' AND [OATABLE044].[COLUMN011]<='Mar 1 6 30 29 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE044].[PK_OATABLE044]), WHERE:([OATABLE044].[COLUMN011]>='Mar 1 2006 12:00AM' AND [OATABLE044].[COLUMN011]<='Mar 14 2007 12:00AM') [OATABLE044].[COLUMN013], [OATABLE044].[COLUMN008], [OATABLE044].[COLUMN007], [OATABLE044].[COLUMN006], [OATABLE044].[COLUMN011], [OATABLE044].[COLUMN002], [OATABLE044].[COLUMN003], [OATABLE044].[COLUMN004], [OATABLE044].[COLUMN010], [OATABLE044].[COLUMN00 4.0 3.7578501E-2 8.2899998E-5 530 0.0376614 [OATABLE044].[COLUMN013], [OATABLE044].[COLUMN008], [OATABLE044].[COLUMN007], [OATABLE044].[COLUMN006], [OATABLE044].[COLUMN011], [OATABLE044].[COLUMN002], [OATABLE044].[COLUMN003], [OATABLE044].[COLUMN004], [OATABLE044].[COLUMN010], [OATABLE044].[COLUMN00 NULL PLAN_ROW 0 1.0
| | | | | | |--Compute Scalar(DEFINE:([Expr1027]=Convert([OATABLE064].[COLUMN003]))) 6 45 27 Compute Scalar Compute Scalar DEFINE:([Expr1027]=Convert([OATABLE064].[COLUMN003])) [Expr1027]=Convert([OATABLE064].[COLUMN003]) 19437.816 0.0 1.9437816E-3 1348 2.5714233 [OATABLE064].[COLUMN017], [OATABLE064].[COLUMN014], [OATABLE064].[COLUMN015], [OATABLE064].[COLUMN013], [OATABLE064].[COLUMN012], [OATABLE064].[COLUMN008], [OATABLE064].[COLUMN007], [OATABLE064].[COLUMN006], [OATABLE064].[COLUMN005], [OATABLE064].[COLUMN00 NULL PLAN_ROW 0 1.0
| | | | | | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE064].[PK_OATABLE064]), WHERE:([OATABLE064].[COLUMN007]>='Mar 1 2006 12:00AM' AND [OATABLE064].[COLUMN007]<='Mar 14 200 6 46 45 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE064].[PK_OATABLE064]), WHERE:([OATABLE064].[COLUMN007]>='Mar 1 2006 12:00AM' AND [OATABLE064].[COLUMN007]<='Mar 14 2007 12:00AM') [OATABLE064].[COLUMN017], [OATABLE064].[COLUMN014], [OATABLE064].[COLUMN015], [OATABLE064].[COLUMN013], [OATABLE064].[COLUMN012], [OATABLE064].[COLUMN008], [OATABLE064].[COLUMN007], [OATABLE064].[COLUMN006], [OATABLE064].[COLUMN005], [OATABLE064].[COLUMN00 19437.816 2.5309119 2.1461399E-2 1387 2.5523732 [OATABLE064].[COLUMN017], [OATABLE064].[COLUMN014], [OATABLE064].[COLUMN015], [OATABLE064].[COLUMN013], [OATABLE064].[COLUMN012], [OATABLE064].[COLUMN008], [OATABLE064].[COLUMN007], [OATABLE064].[COLUMN006], [OATABLE064].[COLUMN005], [OATABLE064].[COLUMN00 NULL PLAN_ROW 0 1.0
| | | | | | |--Compute Scalar(DEFINE:([Expr1065]=Convert([OATABLE065].[COLUMN003]))) 6 51 27 Compute Scalar Compute Scalar DEFINE:([Expr1065]=Convert([OATABLE065].[COLUMN003])) [Expr1065]=Convert([OATABLE065].[COLUMN003]) 11783.293 0.0 1.1783293E-3 1324 1.4362417 [OATABLE065].[COLUMN018], [OATABLE065].[COLUMN015], [OATABLE065].[COLUMN016], [OATABLE065].[COLUMN014], [OATABLE065].[COLUMN013], [OATABLE065].[COLUMN008], [OATABLE065].[COLUMN007], [OATABLE065].[COLUMN006], [OATABLE065].[COLUMN005], [OATABLE065].[COLUMN00 NULL PLAN_ROW 0 1.0
| | | | | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE065].[PK_OATABLE065]), WHERE:([OATABLE065].[COLUMN007]>='Mar 1 2006 12:00AM' AND [OATABLE065].[COLUMN007]<='Mar 14 200 6 52 51 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE065].[PK_OATABLE065]), WHERE:([OATABLE065].[COLUMN007]>='Mar 1 2006 12:00AM' AND [OATABLE065].[COLUMN007]<='Mar 14 2007 12:00AM') [OATABLE065].[COLUMN018], [OATABLE065].[COLUMN015], [OATABLE065].[COLUMN016], [OATABLE065].[COLUMN014], [OATABLE065].[COLUMN013], [OATABLE065].[COLUMN008], [OATABLE065].[COLUMN007], [OATABLE065].[COLUMN006], [OATABLE065].[COLUMN005], [OATABLE065].[COLUMN00 11783.293 0.70582628 6.5204501E-3 1440 1.4246935 [OATABLE065].[COLUMN018], [OATABLE065].[COLUMN015], [OATABLE065].[COLUMN016], [OATABLE065].[COLUMN014], [OATABLE065].[COLUMN013], [OATABLE065].[COLUMN008], [OATABLE065].[COLUMN007], [OATABLE065].[COLUMN006], [OATABLE065].[COLUMN005], [OATABLE065].[COLUMN00 NULL PLAN_ROW 0 1.0
| | | | | |--Concatenation 6 58 11 Concatenation Concatenation NULL [Union1112] = ([Expr1100], [OATABLE030].[COLUMN003]), [Union1113] = ([Expr1101], [OATABLE030].[COLUMN004]) 2.2031577 0.0 3.2304808E-7 313 11.961675 [Union1112], [Union1113] NULL PLAN_ROW 0 25975.924
| | | | | |--Compute Scalar(DEFINE:([Expr1100]=Convert([OATABLE014].[COLUMN003]), [Expr1101]=Convert([OATABLE014].[COLUMN004]))) 6 59 58 Compute Scalar Compute Scalar DEFINE:([Expr1100]=Convert([OATABLE014].[COLUMN003]), [Expr1101]=Convert([OATABLE014].[COLUMN004])) [Expr1100]=Convert([OATABLE014].[COLUMN003]), [Expr1101]=Convert([OATABLE014].[COLUMN004]) 1.0 0.0 0.0000001 313 2.0807185 [Expr1100], [Expr1101] NULL PLAN_ROW 0 25975.924
| | | | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE014].[PK_OATABLE014]), SEEK:([OATABLE014].[COLUMN001]=[Union1077]) ORDERED FORWARD) 6 60 59 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE014].[PK_OATABLE014]), SEEK:([OATABLE014].[COLUMN001]=[Union1077]) ORDERED FORWARD [OATABLE014].[COLUMN004], [OATABLE014].[COLUMN003] 1.0 6.3284999E-3 7.9603E-5 1296 2.0781209 [OATABLE014].[COLUMN004], [OATABLE014].[COLUMN003] NULL PLAN_ROW 0 25975.924
| | | | | |--Nested Loops(Left Outer Join, WHERE:([OATABLE030].[COLUMN009]=If 1 then [GATABLE028].[COLUMN001] else [GATABLE028].[COLUMN001])) 6 69 58 Nested Loops Left Outer Join WHERE:([OATABLE030].[COLUMN009]=If 1 then [GATABLE028].[COLUMN001] else [GATABLE028].[COLUMN001]) NULL 2.2304809 0.0 2.5079999E-4 278 9.8667707 [OATABLE030].[COLUMN004], [OATABLE030].[COLUMN003] NULL PLAN_ROW 0 25975.924
| | | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE030].[PK_OATABLE030]), SEEK:([OATABLE030].[COLUMN001]=[Union1077]) ORDERED FORWARD) 6 70 69 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE030].[PK_OATABLE030]), SEEK:([OATABLE030].[COLUMN001]=[Union1077]) ORDERED FORWARD [OATABLE030].[COLUMN004], [OATABLE030].[COLUMN003], [OATABLE030].[COLUMN009] 1.0 6.3284999E-3 7.9603E-5 250 2.0804186 [OATABLE030].[COLUMN004], [OATABLE030].[COLUMN003], [OATABLE030].[COLUMN009] NULL PLAN_ROW 0 25975.924
| | | | | |--Table Spool 6 71 69 Table Spool Lazy Spool NULL NULL 20.0 1.6756756E-2 0.0000037 36 0.33645731 [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 77927.773
| | | | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028])) 6 72 71 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028]) [GATABLE028].[COLUMN001] 20.0 3.9059982E-2 0.0001005 2532 3.9160483E-2 [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
| | | | |--Concatenation 6 80 10 Concatenation Concatenation NULL [Union1164] = ([OATABLE046].[COLUMN005], [OATABLE048].[COLUMN006], [OATABLE050].[COLUMN007], [OATABLE052].[COLUMN007], [OATABLE056].[COLUMN006], [OATABLE058].[COLUMN006], [OATABLE060].[COLUMN006], [OATABLE062].[COLUMN006], [OATABLE078].[COLUMN005], [OATABL 1072.5612 0.0 0.0000012 44 143.47966 [Union1164] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE046].[PK_OATABLE046]), SEEK:([OATABLE046].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 81 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE046].[PK_OATABLE046]), SEEK:([OATABLE046].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE046].[COLUMN005] 1.0 6.3284999E-3 7.9603E-5 1975 2.9757967 [OATABLE046].[COLUMN005] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE048].[PK_OATABLE048]), SEEK:([OATABLE048].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 82 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE048].[PK_OATABLE048]), SEEK:([OATABLE048].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE048].[COLUMN006] 1.0 6.3284999E-3 7.9603E-5 1975 45.361641 [OATABLE048].[COLUMN006] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE050].[PK_OATABLE050]), SEEK:([OATABLE050].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 83 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE050].[PK_OATABLE050]), SEEK:([OATABLE050].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE050].[COLUMN007] 1.0 6.3284999E-3 7.9603E-5 1432 2.9750118 [OATABLE050].[COLUMN007] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE052].[PK_OATABLE052]), SEEK:([OATABLE052].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 84 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE052].[PK_OATABLE052]), SEEK:([OATABLE052].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE052].[COLUMN007] 1.0 6.3284999E-3 7.9603E-5 84 2.9749331 [OATABLE052].[COLUMN007] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE056].[PK_OATABLE056]), SEEK:([OATABLE056].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 85 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE056].[PK_OATABLE056]), SEEK:([OATABLE056].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE056].[COLUMN006] 1.0 6.3284999E-3 7.9603E-5 2118 66.839722 [OATABLE056].[COLUMN006] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE058].[PK_OATABLE058]), SEEK:([OATABLE058].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 86 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE058].[PK_OATABLE058]), SEEK:([OATABLE058].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE058].[COLUMN006] 1.0 6.3284999E-3 7.9603E-5 1271 2.9759538 [OATABLE058].[COLUMN006] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE060].[PK_OATABLE060]), SEEK:([OATABLE060].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 87 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE060].[PK_OATABLE060]), SEEK:([OATABLE060].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE060].[COLUMN006] 1.0 6.3284999E-3 7.9603E-5 1790 2.9754043 [OATABLE060].[COLUMN006] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE062].[PK_OATABLE062]), SEEK:([OATABLE062].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 88 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE062].[PK_OATABLE062]), SEEK:([OATABLE062].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE062].[COLUMN006] 1.0 6.3284999E-3 7.9603E-5 1887 3.7549496 [OATABLE062].[COLUMN006] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE078].[PK_OATABLE078]), SEEK:([OATABLE078].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 89 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE078].[PK_OATABLE078]), SEEK:([OATABLE078].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE078].[COLUMN005] 1.0 6.3284999E-3 7.9603E-5 84 2.9749331 [OATABLE078].[COLUMN005] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE084].[PK_OATABLE084]), SEEK:([OATABLE084].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 90 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE084].[PK_OATABLE084]), SEEK:([OATABLE084].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE084].[COLUMN006] 1.0 6.3284999E-3 7.9603E-5 163 2.9749331 [OATABLE084].[COLUMN006] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE105].[PK_OATABLE105]), SEEK:([OATABLE105].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 91 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE105].[PK_OATABLE105]), SEEK:([OATABLE105].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE105].[COLUMN004] 1.0 6.3284999E-3 7.9603E-5 930 2.9814398 [OATABLE105].[COLUMN004] NULL PLAN_ROW 0 37291.637
| | | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE107].[PK_OATABLE107]), SEEK:([OATABLE107].[COLUMN001]=[Union1073]) ORDERED FORWARD) 6 92 80 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE107].[PK_OATABLE107]), SEEK:([OATABLE107].[COLUMN001]=[Union1073]) ORDERED FORWARD [OATABLE107].[COLUMN005] 1.0 6.3284999E-3 7.9603E-5 402 3.6701899 [OATABLE107].[COLUMN005] NULL PLAN_ROW 0 37291.637
| | | |--Table Spool 6 94 8 Table Spool Lazy Spool NULL NULL 1.0 1.6756756E-2 2.7999999E-7 11 413.11154 [Expr1168] NULL PLAN_ROW 0 4.0976052E+7
| | | |--Compute Scalar(DEFINE:([Expr1168]=Convert([Expr1413]))) 6 95 94 Compute Scalar Compute Scalar DEFINE:([Expr1168]=Convert([Expr1413])) [Expr1168]=Convert([Expr1413]) 1.0 0.0 0.00000025 11 298.47095 [Expr1168] NULL PLAN_ROW 0 6401.2539
| | | |--Stream Aggregate(DEFINE:([Expr1413]=COUNT_BIG([OATABLE037].[COLUMN005]))) 6 96 95 Stream Aggregate Aggregate NULL [Expr1413]=COUNT_BIG([OATABLE037].[COLUMN005]) 1.0 0.0 0.00000025 11 298.47095 [Expr1413] NULL PLAN_ROW 0 6401.2539
| | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE037].[PK_OATABLE037]), WHERE:(Convert([OATABLE037].[COLUMN001])=[Union1088])) 6 97 96 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE037].[PK_OATABLE037]), WHERE:(Convert([OATABLE037].[COLUMN001])=[Union1088]) [OATABLE037].[COLUMN001], [OATABLE037].[COLUMN005] 1.0 0.17535628 0.0019276 1105 292.22922 [OATABLE037].[COLUMN001], [OATABLE037].[COLUMN005] NULL PLAN_ROW 0 6401.2539
| | |--Table Spool 6 106 7 Table Spool Lazy Spool NULL NULL 1.0 1.6756756E-2 2.7999999E-7 11 413.11154 [Expr1173] NULL PLAN_ROW 0 4.0976052E+7
| | |--Compute Scalar(DEFINE:([Expr1173]=Convert([Expr1414]))) 6 107 106 Compute Scalar Compute Scalar DEFINE:([Expr1173]=Convert([Expr1414])) [Expr1173]=Convert([Expr1414]) 1.0 0.0 0.00000025 11 298.47095 [Expr1173] NULL PLAN_ROW 0 6401.2539
| | |--Stream Aggregate(DEFINE:([Expr1414]=COUNT_BIG([OATABLE037].[COLUMN005]))) 6 108 107 Stream Aggregate Aggregate NULL [Expr1414]=COUNT_BIG([OATABLE037].[COLUMN005]) 1.0 0.0 0.00000025 11 298.47095 [Expr1414] NULL PLAN_ROW 0 6401.2539
| | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE037].[PK_OATABLE037]), WHERE:(Convert([OATABLE037].[COLUMN001])=[Union1088])) 6 109 108 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE037].[PK_OATABLE037]), WHERE:(Convert([OATABLE037].[COLUMN001])=[Union1088]) [OATABLE037].[COLUMN001], [OATABLE037].[COLUMN005] 1.0 0.17535628 0.0019276 1123 292.22922 [OATABLE037].[COLUMN001], [OATABLE037].[COLUMN005] NULL PLAN_ROW 0 6401.2539
| |--Row Count Spool 6 118 6 Row Count Spool Lazy Spool NULL NULL 1.0 0.0 0.0000001 4 298.47275 NULL NULL PLAN_ROW 0 4.0976052E+7
| |--Assert(WHERE:(If ([Expr1389]>1) then 0 else NULL)) 6 119 118 Assert Assert WHERE:(If ([Expr1389]>1) then 0 else NULL) NULL 1.0 0.0 0.00000018 15 298.47211 NULL NULL PLAN_ROW 0 6401.2539
| |--Stream Aggregate(DEFINE:([Expr1389]=Count(*))) 6 120 119 Stream Aggregate Aggregate NULL [Expr1389]=Count(*) 1.0 0.0 0.00000025 15 298.47095 [Expr1389] NULL PLAN_ROW 0 6401.2539
| |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE037].[PK_OATABLE037]), WHERE:(Convert([OATABLE037].[COLUMN001])=[Union1088])) 6 121 120 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE037].[PK_OATABLE037]), WHERE:(Convert([OATABLE037].[COLUMN001])=[Union1088]) [OATABLE037].[COLUMN001] 1.0 0.17535628 0.0019276 1123 292.22922 [OATABLE037].[COLUMN001] NULL PLAN_ROW 0 6401.2539
|--Compute Scalar(DEFINE:([GATABLE028].[COLUMN001]=[GATABLE028].[COLUMN001], [GATABLE028].[COLUMN009]=[GATABLE028].[COLUMN009])) 6 154 2 Compute Scalar Compute Scalar DEFINE:([GATABLE028].[COLUMN001]=[GATABLE028].[COLUMN001], [GATABLE028].[COLUMN009]=[GATABLE028].[COLUMN009]) [GATABLE028].[COLUMN001]=[GATABLE028].[COLUMN001], [GATABLE028].[COLUMN009]=[GATABLE028].[COLUMN009] 110.84717 0.0 1.1084717E-5 2171 4.3260622 [Union1247], [Union1282], [Union1283], [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Expr1356], [Expr1357], [Expr1358], [Expr1359], [Expr1360], [Expr1361], [Expr1362], [Expr1363], [Expr1364], [Expr1365], [Expr1366], [GATABLE028].[COLUMN001], [GATABL NULL PLAN_ROW 0 1.0
|--Compute Scalar(DEFINE:([Expr1358]=Convert([Expr1347]), [Expr1359]=Convert([Expr1348]), [Expr1360]=Convert([Expr1349]), [Expr1361]=Convert([Expr1350]), [Expr1362]=Convert([Expr1351]), [Expr1363]=Convert([Expr1352]), [Expr1364]=Convert([Expr13 6 155 154 Compute Scalar Compute Scalar DEFINE:([Expr1358]=Convert([Expr1347]), [Expr1359]=Convert([Expr1348]), [Expr1360]=Convert([Expr1349]), [Expr1361]=Convert([Expr1350]), [Expr1362]=Convert([Expr1351]), [Expr1363]=Convert([Expr1352]), [Expr1364]=Convert([Expr1351]), [Expr1365]=Convert([Expr [Expr1358]=Convert([Expr1347]), [Expr1359]=Convert([Expr1348]), [Expr1360]=Convert([Expr1349]), [Expr1361]=Convert([Expr1350]), [Expr1362]=Convert([Expr1351]), [Expr1363]=Convert([Expr1352]), [Expr1364]=Convert([Expr1351]), [Expr1365]=Convert([Expr1354]), 110.84717 0.0 1.1084717E-5 1991 4.3260512 [Union1247], [Union1282], [Union1283], [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Expr1356], [Expr1357], [Expr1358], [Expr1359], [Expr1360], [Expr1361], [Expr1362], [Expr1363], [Expr1364], [Expr1365], [Expr1366] NULL PLAN_ROW 0 1.0
|--Compute Scalar(DEFINE:([Expr1356]=If ([Expr1415]=0) then NULL else [Expr1416], [Expr1357]=If ([Expr1417]=0) then NULL else [Expr1418])) 6 156 155 Compute Scalar Compute Scalar DEFINE:([Expr1356]=If ([Expr1415]=0) then NULL else [Expr1416], [Expr1357]=If ([Expr1417]=0) then NULL else [Expr1418]) [Expr1356]=If ([Expr1415]=0) then NULL else [Expr1416], [Expr1357]=If ([Expr1417]=0) then NULL else [Expr1418] 110.84717 0.0 2.0849461E-2 598 4.3260403 [Union1247], [Union1282], [Union1283], [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Expr1347], [Expr1348], [Expr1349], [Expr1350], [Expr1351], [Expr1352], [Expr1354], [Expr1356], [Expr1357] NULL PLAN_ROW 0 1.0
|--Stream Aggregate(GROUP BY:([Union1247], [Union1283], [Union1282]) DEFINE:([Expr1415]=COUNT_BIG([Union1253]), [Expr1416]=SUM([Union1253]), [Expr1417]=COUNT_BIG([Union1254]), [Expr1418]=SUM([Union1254]), [GATABLE028].[COLUMN001]=ANY( 6 157 156 Stream Aggregate Aggregate GROUP BY:([Union1247], [Union1283], [Union1282]) [Expr1415]=COUNT_BIG([Union1253]), [Expr1416]=SUM([Union1253]), [Expr1417]=COUNT_BIG([Union1254]), [Expr1418]=SUM([Union1254]), [GATABLE028].[COLUMN001]=ANY([GATABLE028].[COLUMN001]), [GATABLE028].[COLUMN009]=ANY([GATABLE028].[COLUMN009]), [Expr1347]=ANY([ 110.84717 0.0 2.0849461E-2 598 4.3260403 [Union1247], [Union1282], [Union1283], [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Expr1347], [Expr1348], [Expr1349], [Expr1350], [Expr1351], [Expr1352], [Expr1354], [Expr1415], [Expr1416], [Expr1417], [Expr1418] NULL PLAN_ROW 0 1.0
|--Compute Scalar(DEFINE:([Expr1347]='OpenBal', [Expr1348]='OPBAL', [Expr1349]='OPENTRANSID', [Expr1350]='Opening Balance', [Expr1351]='', [Expr1352]=0, [Expr1354]='Brought Forward Balance')) 6 158 157 Compute Scalar Compute Scalar DEFINE:([Expr1347]='OpenBal', [Expr1348]='OPBAL', [Expr1349]='OPENTRANSID', [Expr1350]='Opening Balance', [Expr1351]='', [Expr1352]=0, [Expr1354]='Brought Forward Balance') [Expr1347]='OpenBal', [Expr1348]='OPBAL', [Expr1349]='OPENTRANSID', [Expr1350]='Opening Balance', [Expr1351]='', [Expr1352]=0, [Expr1354]='Brought Forward Balance' 7262.1504 0.0 7.2621502E-4 598 4.3051906 [Union1247], [Union1253], [Union1254], [Union1282], [Union1283], [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001], [Expr1347], [Expr1348], [Expr1349], [Expr1350], [Expr1351], [Expr1352], [Expr1354] NULL PLAN_ROW 0 1.0
|--Nested Loops(Left Outer Join, OUTER REFERENCES:([Union1243])) 6 160 158 Nested Loops Left Outer Join OUTER REFERENCES:([Union1243]) NULL 7262.1504 0.0 2.9632291E-2 580 4.3037381 [Union1247], [Union1253], [Union1254], [Union1282], [Union1283], [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
|--Sort(ORDER BY:([Union1247] ASC, [Union1283] ASC, [Union1282] ASC)) 6 161 160 Sort Sort ORDER BY:([Union1247] ASC, [Union1283] ASC, [Union1282] ASC) NULL 6.6094732 1.1261261E-2 1.2867208E-4 580 4.1916194 [Union1243], [Union1247], [Union1253], [Union1254], [Union1282], [Union1283], [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
| |--Nested Loops(Inner Join, OUTER REFERENCES:([Union1247])) 6 162 161 Nested Loops Inner Join OUTER REFERENCES:([Union1247]) NULL 6.6094732 0.0 2.7627599E-5 5476 4.1802297 [Union1243], [Union1247], [Union1253], [Union1254], [Union1282], [Union1283], [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
| |--Nested Loops(Inner Join) 6 163 162 Nested Loops Inner Join NULL NULL 3.0 0.0 0.00001254 5172 4.1261358 [Union1243], [Union1247], [Union1253], [Union1254], [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
| | |--Nested Loops(Left Outer Join, OUTER REFERENCES:([GATABLE028].[COLUMN001])) 6 164 163 Nested Loops Left Outer Join OUTER REFERENCES:([GATABLE028].[COLUMN001]) NULL 1.0 0.0 4.1799999E-6 2532 4.4841822E-2 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
| | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028]), SEEK:([GATABLE028].[COLUMN001]='03E347F0-410C-4AD2-8151-5EB88EAB0FB9') ORDERED FORWARD) 6 165 164 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028]), SEEK:([GATABLE028].[COLUMN001]='03E347F0-410C-4AD2-8151-5EB88EAB0FB9') ORDERED FORWARD [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001] 1.0 6.3284999E-3 7.9603E-5 2532 6.4081028E-3 [GATABLE028].[COLUMN009], [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
| | | |--Top(1) 6 166 164 Top Top NULL NULL 1.0 0.0 0.0000001 4 0.03842954 NULL NULL PLAN_ROW 0 1.0
| | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE049].[PK_GATABLE049]), WHERE:([GATABLE049].[COLUMN002]=[GATABLE028].[COLUMN001])) 6 168 166 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE049].[PK_GATABLE049]), WHERE:([GATABLE049].[COLUMN002]=[GATABLE028].[COLUMN001]) [GATABLE049].[COLUMN002] 1.0 1.9159621E-2 5.0250001E-5 1276 3.8419742E-2 [GATABLE049].[COLUMN002] NULL PLAN_ROW 0 1.0
| | |--Nested Loops(Left Outer Join, OUTER REFERENCES:([GATABLE028].[COLUMN001])) 6 170 163 Nested Loops Left Outer Join OUTER REFERENCES:([GATABLE028].[COLUMN001]) NULL 3.0 0.0 0.00001254 2648 4.0812812 [Union1243], [Union1247], [Union1253], [Union1254] NULL PLAN_ROW 0 1.0
| | |--Nested Loops(Inner Join, OUTER REFERENCES:([Union1241])) 6 171 170 Nested Loops Inner Join OUTER REFERENCES:([Union1241]) NULL 3.0 0.0 0.00001254 2648 4.0425963 [Union1243], [Union1247], [Union1253], [Union1254], [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 1.0
| | | |--Concatenation 6 172 171 Concatenation Concatenation NULL [Union1241] = ([OATABLE044].[COLUMN010], [OATABLE064].[COLUMN002], [OATABLE065].[COLUMN002]), [Union1243] = ([OATABLE044].[COLUMN001], [OATABLE064].[COLUMN004], [OATABLE065].[COLUMN004]), [Union1247] = ([OATABLE044].[COLUMN006], [OATABLE064].[COLUMN008], [ 3.0 0.0 3.0000001E-7 124 4.0359626 [Union1241], [Union1243], [Union1247], [Union1253], [Union1254] NULL PLAN_ROW 0 1.0
| | | | |--Filter(WHERE:([OATABLE044].[COLUMN011]<'Mar 1 2006 12:00AM')) 6 173 172 Filter Filter WHERE:([OATABLE044].[COLUMN011]<'Mar 1 2006 12:00AM') NULL 1.0 0.0 1.9199999E-6 132 3.7664119E-2 [OATABLE044].[COLUMN006], [OATABLE044].[COLUMN010], [OATABLE044].[COLUMN001], [OATABLE044].[COLUMN007], [OATABLE044].[COLUMN008] NULL PLAN_ROW 0 1.0
| | | | | |--Compute Scalar(DEFINE:([OATABLE044].[COLUMN001]=[OATABLE044].[COLUMN001], [OATABLE044].[COLUMN007]=[OATABLE044].[COLUMN007], [OATABLE044].[COLUMN008]=[OATABLE044].[COLUMN008], [OATA 6 174 173 Compute Scalar Compute Scalar DEFINE:([OATABLE044].[COLUMN001]=[OATABLE044].[COLUMN001], [OATABLE044].[COLUMN007]=[OATABLE044].[COLUMN007], [OATABLE044].[COLUMN008]=[OATABLE044].[COLUMN008], [OATABLE044].[COLUMN011]=[OATABLE044].[COLUMN011]) [OATABLE044].[COLUMN001]=[OATABLE044].[COLUMN001], [OATABLE044].[COLUMN007]=[OATABLE044].[COLUMN007], [OATABLE044].[COLUMN008]=[OATABLE044].[COLUMN008], [OATABLE044].[COLUMN011]=[OATABLE044].[COLUMN011] 4.0 0.0 0.0000004 132 3.7662201E-2 [OATABLE044].[COLUMN006], [OATABLE044].[COLUMN010], [OATABLE044].[COLUMN001], [OATABLE044].[COLUMN007], [OATABLE044].[COLUMN008], [OATABLE044].[COLUMN011] NULL PLAN_ROW 0 1.0
| | | | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE044].[PK_OATABLE044])) 6 176 174 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE044].[PK_OATABLE044]) [OATABLE044].[COLUMN008], [OATABLE044].[COLUMN007], [OATABLE044].[COLUMN006], [OATABLE044].[COLUMN011], [OATABLE044].[COLUMN010], [OATABLE044].[COLUMN001] 4.0 3.7578501E-2 8.2899998E-5 605 0.0376614 [OATABLE044].[COLUMN008], [OATABLE044].[COLUMN007], [OATABLE044].[COLUMN006], [OATABLE044].[COLUMN011], [OATABLE044].[COLUMN010], [OATABLE044].[COLUMN001] NULL PLAN_ROW 0 1.0
| | | | |--Filter(WHERE:([OATABLE064].[COLUMN007]<'Mar 1 2006 12:00AM')) 6 190 172 Filter Filter WHERE:([OATABLE064].[COLUMN007]<'Mar 1 2006 12:00AM') NULL 1.0 0.0 9.3307197E-3 132 2.5655918 [OATABLE064].[COLUMN013], [OATABLE064].[COLUMN012], [OATABLE064].[COLUMN008], [OATABLE064].[COLUMN004], [OATABLE064].[COLUMN002] NULL PLAN_ROW 0 1.0
| | | | | |--Compute Scalar(DEFINE:([OATABLE064].[COLUMN007]=[OATABLE064].[COLUMN007])) 6 191 190 Compute Scalar Compute Scalar DEFINE:([OATABLE064].[COLUMN007]=[OATABLE064].[COLUMN007]) [OATABLE064].[COLUMN007]=[OATABLE064].[COLUMN007] 19439.0 0.0 0.0019439 132 2.5562611 [OATABLE064].[COLUMN013], [OATABLE064].[COLUMN012], [OATABLE064].[COLUMN008], [OATABLE064].[COLUMN004], [OATABLE064].[COLUMN002], [OATABLE064].[COLUMN007] NULL PLAN_ROW 0 1.0
| | | | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE064].[PK_OATABLE064])) 6 193 191 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE064].[PK_OATABLE064]) [OATABLE064].[COLUMN013], [OATABLE064].[COLUMN012], [OATABLE064].[COLUMN008], [OATABLE064].[COLUMN007], [OATABLE064].[COLUMN004], [OATABLE064].[COLUMN002] 19439.0 2.5309119 2.1461399E-2 1638 2.5523732 [OATABLE064].[COLUMN013], [OATABLE064].[COLUMN012], [OATABLE064].[COLUMN008], [OATABLE064].[COLUMN007], [OATABLE064].[COLUMN004], [OATABLE064].[COLUMN002] NULL PLAN_ROW 0 1.0
| | | | |--Filter(WHERE:([OATABLE065].[COLUMN007]<'Mar 1 2006 12:00AM')) 6 201 172 Filter Filter WHERE:([OATABLE065].[COLUMN007]<'Mar 1 2006 12:00AM') NULL 1.0 0.0 5.6563201E-3 132 1.4327066 [OATABLE065].[COLUMN014], [OATABLE065].[COLUMN013], [OATABLE065].[COLUMN008], [OATABLE065].[COLUMN004], [OATABLE065].[COLUMN002] NULL PLAN_ROW 0 1.0
| | | | |--Compute Scalar(DEFINE:([OATABLE065].[COLUMN007]=[OATABLE065].[COLUMN007])) 6 202 201 Compute Scalar Compute Scalar DEFINE:([OATABLE065].[COLUMN007]=[OATABLE065].[COLUMN007]) [OATABLE065].[COLUMN007]=[OATABLE065].[COLUMN007] 11784.0 0.0 0.0011784 132 1.4270502 [OATABLE065].[COLUMN014], [OATABLE065].[COLUMN013], [OATABLE065].[COLUMN008], [OATABLE065].[COLUMN004], [OATABLE065].[COLUMN002], [OATABLE065].[COLUMN007] NULL PLAN_ROW 0 1.0
| | | | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE065].[PK_OATABLE065])) 6 204 202 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE065].[PK_OATABLE065]) [OATABLE065].[COLUMN014], [OATABLE065].[COLUMN013], [OATABLE065].[COLUMN008], [OATABLE065].[COLUMN007], [OATABLE065].[COLUMN004], [OATABLE065].[COLUMN002] 11784.0 0.70582628 6.5204501E-3 1725 1.4246935 [OATABLE065].[COLUMN014], [OATABLE065].[COLUMN013], [OATABLE065].[COLUMN008], [OATABLE065].[COLUMN007], [OATABLE065].[COLUMN004], [OATABLE065].[COLUMN002] NULL PLAN_ROW 0 1.0
| | | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028]), SEEK:([GATABLE028].[COLUMN001]=[Union1241]), WHERE:([GATABLE028].[COLUMN030]='03E347F0-410C-4AD2-8151-5EB 6 212 171 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028]), SEEK:([GATABLE028].[COLUMN001]=[Union1241]), WHERE:([GATABLE028].[COLUMN030]='03E347F0-410C-4AD2-8151-5EB88EAB0FB9') ORDERED FORWARD [GATABLE028].[COLUMN030], [GATABLE028].[COLUMN001] 1.0 6.3284999E-3 7.9603E-5 2532 6.6196425E-3 [GATABLE028].[COLUMN030], [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 3.0
| | |--Row Count Spool 6 213 170 Row Count Spool Lazy Spool NULL NULL 1.0 0.0 1.0011158E-4 4 0.03867241 NULL NULL PLAN_ROW 0 3.0
| | |--Top(1) 6 214 213 Top Top NULL NULL 1.0 0.0 0.0000001 4 3.8563151E-2 NULL NULL PLAN_ROW 0 2.2113249
| | |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE049].[PK_GATABLE049]), WHERE:([GATABLE049].[COLUMN002]=[GATABLE028].[COLUMN001])) 6 216 214 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE049].[PK_GATABLE049]), WHERE:([GATABLE049].[COLUMN002]=[GATABLE028].[COLUMN001]) [GATABLE049].[COLUMN002] 1.0 3.8319241E-2 0.0001005 1276 3.8541477E-2 [GATABLE049].[COLUMN002] NULL PLAN_ROW 0 2.2113249
| |--Concatenation 6 218 162 Concatenation Concatenation NULL [Union1282] = ([Expr1270], [OATABLE030].[COLUMN003]), [Union1283] = ([Expr1271], [OATABLE030].[COLUMN004]) 2.2031577 0.0 3.2304808E-7 313 5.4066103E-2 [Union1282], [Union1283] NULL PLAN_ROW 0 3.0
| |--Compute Scalar(DEFINE:([Expr1270]=Convert([OATABLE014].[COLUMN003]), [Expr1271]=Convert([OATABLE014].[COLUMN004]))) 6 219 218 Compute Scalar Compute Scalar DEFINE:([Expr1270]=Convert([OATABLE014].[COLUMN003]), [Expr1271]=Convert([OATABLE014].[COLUMN004])) [Expr1270]=Convert([OATABLE014].[COLUMN003]), [Expr1271]=Convert([OATABLE014].[COLUMN004]) 1.0 0.0 0.0000001 313 6.6199424E-3 [Expr1270], [Expr1271] NULL PLAN_ROW 0 3.0
| | |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE014].[PK_OATABLE014]), SEEK:([OATABLE014].[COLUMN001]=[Union1247]) ORDERED FORWARD) 6 220 219 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE014].[PK_OATABLE014]), SEEK:([OATABLE014].[COLUMN001]=[Union1247]) ORDERED FORWARD [OATABLE014].[COLUMN004], [OATABLE014].[COLUMN003] 1.0 6.3284999E-3 7.9603E-5 1371 6.6196425E-3 [OATABLE014].[COLUMN004], [OATABLE014].[COLUMN003] NULL PLAN_ROW 0 3.0
| |--Nested Loops(Left Outer Join, WHERE:([OATABLE030].[COLUMN009]=If 1 then [GATABLE028].[COLUMN001] else [GATABLE028].[COLUMN001])) 6 229 218 Nested Loops Left Outer Join WHERE:([OATABLE030].[COLUMN009]=If 1 then [GATABLE028].[COLUMN001] else [GATABLE028].[COLUMN001]) NULL 2.2304809 0.0 2.5079999E-4 3089 4.7444522E-2 [OATABLE030].[COLUMN004], [OATABLE030].[COLUMN003] NULL PLAN_ROW 0 3.0
| |--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE030].[PK_OATABLE030]), SEEK:([OATABLE030].[COLUMN001]=[Union1247]) ORDERED FORWARD) 6 230 229 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE030].[PK_OATABLE030]), SEEK:([OATABLE030].[COLUMN001]=[Union1247]) ORDERED FORWARD [OATABLE030].[COLUMN004], [OATABLE030].[COLUMN003], [OATABLE030].[COLUMN009] 1.0 6.3284999E-3 7.9603E-5 565 6.6196425E-3 [OATABLE030].[COLUMN004], [OATABLE030].[COLUMN003], [OATABLE030].[COLUMN009] NULL PLAN_ROW 0 3.0
| |--Clustered Index Scan(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028])) 6 231 229 Clustered Index Scan Clustered Index Scan OBJECT:([AOFL-MAR-01-LIVE].[dbo].[GATABLE028].[PK_GATABLE028]) [GATABLE028].[COLUMN001] 20.0 3.9059982E-2 0.0001005 2532 3.9964482E-2 [GATABLE028].[COLUMN001] NULL PLAN_ROW 0 9.0
|--Row Count Spool 6 239 160 Row Count Spool Lazy Spool NULL NULL 1072.5612 0.0 1.0725612E-4 4 8.2486495E-2 NULL NULL PLAN_ROW 0 6.6094732
|--Concatenation 6 240 239 Concatenation Concatenation NULL NULL 1072.5612 0.0 0.0000012 36 8.2030579E-2 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE046].[PK_OATABLE046]), SEEK:([OATABLE046].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 241 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE046].[PK_OATABLE046]), SEEK:([OATABLE046].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 1964 6.8303477E-3 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE048].[PK_OATABLE048]), SEEK:([OATABLE048].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 242 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE048].[PK_OATABLE048]), SEEK:([OATABLE048].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 1964 6.9187074E-3 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE050].[PK_OATABLE050]), SEEK:([OATABLE050].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 243 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE050].[PK_OATABLE050]), SEEK:([OATABLE050].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 1421 6.7083235E-3 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE052].[PK_OATABLE052]), SEEK:([OATABLE052].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 244 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE052].[PK_OATABLE052]), SEEK:([OATABLE052].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 84 6.7466726E-3 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE056].[PK_OATABLE056]), SEEK:([OATABLE056].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 245 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE056].[PK_OATABLE056]), SEEK:([OATABLE056].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 2107 6.9205626E-3 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE058].[PK_OATABLE058]), SEEK:([OATABLE058].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 246 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE058].[PK_OATABLE058]), SEEK:([OATABLE058].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 1260 6.8370439E-3 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE060].[PK_OATABLE060]), SEEK:([OATABLE060].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 247 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE060].[PK_OATABLE060]), SEEK:([OATABLE060].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 1779 6.8355221E-3 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE062].[PK_OATABLE062]), SEEK:([OATABLE062].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 248 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE062].[PK_OATABLE062]), SEEK:([OATABLE062].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 1876 6.9147954E-3 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE078].[PK_OATABLE078]), SEEK:([OATABLE078].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 249 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE078].[PK_OATABLE078]), SEEK:([OATABLE078].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 84 6.7466726E-3 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE084].[PK_OATABLE084]), SEEK:([OATABLE084].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 250 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE084].[PK_OATABLE084]), SEEK:([OATABLE084].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 163 6.7466726E-3 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE105].[PK_OATABLE105]), SEEK:([OATABLE105].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 251 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE105].[PK_OATABLE105]), SEEK:([OATABLE105].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 908 6.9074281E-3 NULL NULL PLAN_ROW 0 4.2507458
|--Clustered Index Seek(OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE107].[PK_OATABLE107]), SEEK:([OATABLE107].[COLUMN001]=[Union1243]) ORDERED FORWARD) 6 252 240 Clustered Index Seek Clustered Index Seek OBJECT:([AOFL-MAR-01-LIVE].[dbo].[OATABLE107].[PK_OATABLE107]), SEEK:([OATABLE107].[COLUMN001]=[Union1243]) ORDERED FORWARD NULL 1.0 6.3284999E-3 7.9603E-5 380 6.9127283E-3 NULL NULL PLAN_ROW 0 4.2507458

the query is taking 5 min time.please help to tune thsi query.

thanks in advance.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-14 : 05:35:56

We are already helping you out here!
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80512

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources