Originally posted by msuresh
hi,
My query is select * from log_record order by tran_datetime desc;

This table is having millions of record.What to do now???
there is no options to speed up this query with indexes. The only thing, what you should do - to tune sort operations in your database.