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

This table is having millions of record.What to do now???