|Subject||RE: [firebird-support] Order by|
> I have a query which gets data from 2 tables. Number of records read isfascinating - but tell us the query, query plan, table structure,
> 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.
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