Re: elminating filesort

2004-01-06 Thread Dan Nelson
In the last episode (Jan 06), Ludwig Pummer said: > I'm trying to eliminate a filesort from a very simple query but > having no luck. Even though I've read the manual section on when > indexes are used in conjunction with ORDER BY, it seems I just can't > get an index to be used. Sometimes a files

elminating filesort

2004-01-06 Thread Ludwig Pummer
Hello folks :) I'm trying to eliminate a filesort from a very simple query but having no luck. Even though I've read the manual section on when indexes are used in conjunction with ORDER BY, it seems I just can't get an index to be used. I'm running MySQL 3.23.58. The table: CREATE TABLE `min