Hi, im hoping to solve a problem that is bugging me!
I just moved a database from a development server to production (test), several of the fields have auto-increment ticked but as it is mainly a data warehouse i thought nothing of it. I then found that a lot of my queries were running slow and the select_full_joins variable was incrementing slowly. EXPLAIN on the queries found that the optimizer was ignoring some indexes, when i put the auto-increment back on the optimizer suddenly starts to use the index again.
Why would this be?? Thanks Ade -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
