OTECTED]>
To: "Bob O'Neill" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, June 03, 2005 3:20 PM
Subject: Re: max_seeks_for_key in InnoDB
Hi,
you can use a hint to force specific index usage :
http://lib.hutech.edu.vn/ebookonline/ebook1/0596003064/hpmysql-CHP-5-SECT-4.html
But this
Hi,
you can use a hint to force specific index usage :
http://lib.hutech.edu.vn/ebookonline/ebook1/0596003064/hpmysql-CHP-5-SECT-4.html
But this is not a good idea since data change and index selectivity can become
bad.
Also, if the index scan + the table scan is bigger than a full table scan, ev
I am having problems with MySQL inconsistently choosing the wrong index, or no
index at all, for queries on tables with 20 million rows. Would it be a good
idea for me to set max_seeks_for_key to 1 (or something less than 4 billion),
in order to force MySQL to use an index? We are using InnoDB