Hello all,

I have some quiries with joins of different tables and at the end order by statement. These quiries take very longer time from 7 Min to more.
The Records in the datatbase are more than half million
When ever I remove the order by clause the the quiries pull out with in seconds.

Please help me out of this problem.
Thanks in advance

Run with set explain on and see what goes there !

For optimize if the query return many records try to to

select ... into temp temptable
create index on temptable
select * from tenptable

Hope that help you