Subject Order by
Author Sandeep Chandra
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