Re: Select always "Using FileSort"

At 10:10 AM 10/15/2003, you wrote: In the last episode (Oct 15), mos said: > At 07:47 AM 10/15/2003, you wrote: > >mos <[EMAIL PROTECTED]> wrote: > >> I want to speed up a large query and I noticed if I do an: > >> > >> Explain select * from LargeTable order by IndexCol1 > >> > >> it always has Ext

Re: Select always "Using FileSort"

In the last episode (Oct 15), mos said: > At 07:47 AM 10/15/2003, you wrote: > >mos <[EMAIL PROTECTED]> wrote: > >> I want to speed up a large query and I noticed if I do an: > >> > >> Explain select * from LargeTable order by IndexCol1 > >> > >> it always has Extra "Using FileSort", which means it

Re: Select always "Using FileSort"

At 07:47 AM 10/15/2003, you wrote: mos <[EMAIL PROTECTED]> wrote: > I want to speed up a large query and I noticed if I do an: > > Explain select * from LargeTable order by IndexCol1 > > it always has Extra "Using FileSort", which means it is physically sorting > the result set. > I've tried differ

Re: Select always "Using FileSort"

mos <[EMAIL PROTECTED]> wrote: > I want to speed up a large query and I noticed if I do an: > > Explain select * from LargeTable order by IndexCol1 > > it always has Extra "Using FileSort", which means it is physically sorting > the result set. > I've tried different tables and sorted on differe

Re: Select always "Using FileSort"

Whenever you use select * MySQL will skip using index. For more information, http://www.mysql.com/doc/en/MySQL_indexes.html . Thanks, Ram >>> mos <[EMAIL PROTECTED]> 10/15/2003 10:17:22 AM >>> I want to speed up a large query and I noticed if I do an: Explain select * from LargeTable order by

Select always "Using FileSort"

I want to speed up a large query and I noticed if I do an: Explain select * from LargeTable order by IndexCol1 it always has Extra "Using FileSort", which means it is physically sorting the result set. I've tried different tables and sorted on different index columns, and it is always using Fil