Subject RE: [firebird-support] Order by
Author Alan McDonald
> 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

fascinating - but tell us the query, query plan, table structure,
application language, connection libraries etc - tell us something so we can
make an educated guess as to what is happening - on the face of it I'd say