>>>>> "forbbs" == forbbs forbbs <bbsexclusive@stripped> writes:
forbbs> I give lying information in the info() function and records_in_range()
forbbs> to force the query using index.
forbbs> For example: 'id' is key. When the query is like 'select ... from ..
forbbs> where id = 5', the index is used. But when it comes to range query
forbbs> like ''select ... from .. where id > 5', full table scan is used.
The scan is used if the query is likely to touch more than 30 % of the
table (because in this case the table scan is usually faster than the
The following manual entry tells you how to force the index:
See the entry regarding FORCE INDEX.