July 31, 2003 at 2:47 am
I am experiencing a response problem when executing two simple select statements
The statement one:
select top 63 * from statement_header
where run_id = 9
Takes a second to return the result set
The statement two:
select top 64 * from statement_header
where run_id = 9
Takes 50 seconds to return the result set
There is a different in the execution plans for the statements. The first one use a bookmark in a clustered index and the second is not.
Our DBA has updated statistics and rebuild the indexes, but with no luck.
Does anyone have any other suggestions?
Melani
July 31, 2003 at 3:35 am
Although I hate to resort to it... you can try an index hint in the query to force the clustered index use.
Cheers,
- Mark
Cheers,
- Mark
July 31, 2003 at 3:37 am
Although I hate to resort to it... you can try an index hint in the query to force the clustered index use.
Cheers,
- Mark
Cheers,
- Mark
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply