September 27, 2009 at 11:22 pm
Good day
I have the following query:
Select
T2.Line_Of_Business_Code As Line_Of_Business,
T2.Ledger_Type,
T2.Period_End_Date,
T2.Fiscal_Pattern,
T3.Company_Code as Company,
T2.Company As BU_Company,
T2.Object_Account,
T2.Subsidiary,
T2.Opening_Balance,
T2.Closing_Balance,
T2.Movement,
T3.Country_Of_Ultimate_Owner_Code As Service_Line
From
dbo.vw_Balance_Income T2
Left Outer Join
DM_Dim_Business_Unit T3
on
T2.Business_Unit = T3.Business_Unit_Code
WHERE
T2.Period_End_Date > '2007/12/31' And Cast(T2.Account_Id As int) < 1156895 When I look at the execution plan it refrences a table that do no appear in the query. Is this because of the partition? Maybe someone can tel me why this is happening. I attached the execution plan. Please let me know if more info is needed.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
September 27, 2009 at 11:54 pm
No worries found the problem. Experiencing the monday stupidity.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
September 28, 2009 at 6:48 am
Just for curiousity, what did you do to solve the performance issue?
I see a function on a column in the WHERE clause that will prevent index use. Was that it?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply