Hi, I have a strange time out issue on a simple select statement.
This is my select statement:
Select * from DyGeJournal where ord>=4609635 and Fracsec>=31
The ord and Fracsec is the primary key.
When I ask for the actual excecution plan, he is using a an index seek.
It takes more than 1,5 minutes to get a result back.
When I shrink my database, everyting is running as expected, the query above runs in milliseconds.
After a while (2 weeks) it start agian running very slow.
I have the same logic on other tables, but I don't have the problem on those tables.
What can cause this problem?
View Complete Post