Re: Performance in ORDER BY

"jabelsc" <jabelsc_at_gmail.com> wrote:
> Thanks a lot to you all!!

Please quote a little bit of context.

> I've tested with the solution proposed by Xho, but the response time is
> even slower.
> Which indexes do you recommend me to create?

Off the top of my head, timestmp (start_time, status) would probably be most likely to succeed. It is hard to tell without explain plans, table descriptions, already existing indexes, stats, etc. It is always possible that there is just no efficient way to do what you want.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB