Posted by Willem on 12/27/05 18:17

Can't you use a FORCE clause to force the use of an index?

Adam wrote:
> In where I use the "BETWEEN start AND stop"
> on field that has an index.
>
> but if the range exceed some value
> optimalizator drops the usage of index and
> go through all records :(
> e.g.
> "BETWEEN 222 AND 299 " --> 20649 (usage of index)
> "BETWEEN 222 AND 300 " --> 123063 (no index used)
> Result set contains similar nr of rows
>
> witch limit is exceeded in this situation?
> witch mysql param should I increase?
>

[Back to original message]