Re: Select always "Using FileSort"

2003-10-16 Thread mos
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"

2003-10-15 Thread Dan Nelson
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"

2003-10-15 Thread mos
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"

2003-10-15 Thread Egor Egorov
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"

2003-10-15 Thread Prasad Budim Ram
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