Hi,
We have this situation:
select * from MyTable where match (col) against
("foo") limit 10;
takes <1s, but:
select * from MyTable where match (col) against
("foo") and col2 = 15;
takes ~4s.
col is a text field w/fulltext index, and col2 int
unsigned w/standard index.
So, what I was thinking would speed this up, would be:
alter table MyTable drop index col, add fulltext index
(col, col2);
But, this makes both columns a fulltext index. We
would want col a fulltext index , and col2 a standard
index. Is something like this possible (if so, what
syntax)?
If not, any other ideas for speeding this query up?
Thanks!
__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
