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
Showing posts with label secunds. Show all posts
Showing posts with label secunds. Show all posts
Subscribe to:
Posts (Atom)