Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Can I push an Index hint down into a base tables from a view RE: Can I push an Index hint down into a base tables from a view
SwePeso
SSC-Dedicated
Points: 39752
More actions
February 13, 2009 at 3:07 am
#943421
It would help if you posted the view definition.
Maybe something is seriously wrong there?
SELECTSUM(Amount)
FROMvwCashTransactions
WHEREGroupAccountID = @P1
AND LedgerDate BETWEEN @P2 AND @P3
N 56°04'39.16"E 12°55'05.25"