It's not really necessary for you to adjust that variable.
-Original Message-
From: jitendra ranjan [mailto:jitendra_ran...@yahoo.com]
Sent: Tuesday, August 17, 2010 7:52 AM
To: mysql@lists.mysql.com
Subject: max_seeks_for_key
Hi,
We have myisam tables which has round 10 lakhs of recor
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
