You can optimize you indexes with the myisamchk command and the --analyze parameter. If you are using InnoDB tables, I don't think there is a way to do this.
On Thursday, September 11, 2003, at 01:30 PM, Tongprasith, Anan wrote:
I have two tables which are exactly the same but have different set of data on them. I wrote a query and used EXPLAIN to see how it would run on each table.
It turn out that the same query will use index on one table but not the other. So I delete all data on the "bad" table (the one that won't use index) and copy data from the "good" table over.
Now it says it will use index. Is this a bug?
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]