List:Internals« Previous MessageNext Message »
From:forbbs forbbs Date:March 2 2009 1:35am
Subject:how to force index using.
View as plain text  
I give lying information in the info() function and records_in_range()
to force the query using index.
For example: 'id' is key. When the query is like 'select ... from ..
where id = 5', the index is used. But when it comes to range query
like ''select ... from .. where id > 5', full table scan is used.
Thread
how to force index using.forbbs forbbs2 Mar
  • re: how to force index using.Michael Widenius2 Mar