Victor Pendleton wrote:
What does the explain plan look like? It sounds like the query is using the
fulltext index. Remember that only one index per table can be used when
performing a query.
explain select id, headline, date_format(s.post_date,'%Y/%m/%d')
directory, post_date sort_date
from stor
What does the explain plan look like? It sounds like the query is using the
fulltext index. Remember that only one index per table can be used when
performing a query.
-Original Message-
From: Jon Drukman
To: [EMAIL PROTECTED]
Sent: 6/2/04 11:57 AM
Subject: avoiding Using filesort
i&#x
i've read the ORDER BY optimization page in the manual but i'm stumped
by my inability to get this query to avoid the filesort.
the table structure is:
CREATE TABLE story (
id int(11) NOT NULL auto_increment,
headline text,
deck text,
free_override tinyint(1) NOT NULL default '0',
outpu
