>I am using the FlameRobin tool to execute the query. > >I write the select query like select first 100 * from XXX , I am able to get >the result. >But when use one more query select first 110 * from XXX , I am not able to get >the data, >still it is in process to get the Data. I am surprise for getting another 10 >extra records >why it is taking so much time. > >I don't know where is the problem, please let me know if you have faced this >type of >problem how you resolved this.
Luckily (for me, not for you), this is a type of problem that I know virtually nothing about and that others on this list can (and hopefull will) answer much better. Still, I do have a few questions. I assume SELECT FIRST 20 SKIP 90 * FROM XXX also is slow? I also assume you don't have any WHERE clause? Have you tried the same select on a freshly restored database (assuming it could be some corruption within the database that might or might not give an error during backup or restore)? HTH, Set
