When I am executing a simple select query in a database with correct index set it takes a long time (over 30 secunds) to execute. In another database with an identical table it runs on less then one second.
The differense I can find is that when I check execution plan on the slow database I get the arguments of the index scan to "convert([table].[column])=Convert([@.1]) and i don't get this in the other database. Does anyone have any idea on why?
Best Regards HalTry updating statistics and recreating indexes on your slow database.
blindman|||I have the update statistics automaticly set to true. Should I do that anyway?
//Hal
Originally posted by blindman
Try updating statistics and recreating indexes on your slow database.
blindman
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment