Subject | Order by |
---|---|
Author | Sandeep Chandra |
Post date | 2003-11-30T21:25:55Z |
I have a query which gets data from 2 tables. Number of records read is
45 without order by clause, as soon as I put order by clause it goes to
360. In both cases the profile says "Indexed Reads".
This is slowing the server and all the workstations.
Why is this happening? How do I fix this so that other workstations are
not slowed down.
Regards
Sandeep
45 without order by clause, as soon as I put order by clause it goes to
360. In both cases the profile says "Indexed Reads".
This is slowing the server and all the workstations.
Why is this happening? How do I fix this so that other workstations are
not slowed down.
Regards
Sandeep