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