Re: max_seeks_for_key in InnoDB

2005-06-07 Thread Bob O'Neill
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

Re: max_seeks_for_key in InnoDB

2005-06-03 Thread mfatene
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