| 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 forbbs | 2 Mar |
| • re: how to force index using. | Michael Widenius | 2 Mar |
