Re[2]: [sqlite] The problem with index

[Sergey M. Brytsko]

But what about the following values:

1 1 2 2 100 100 100 100 100 100 100 100 100 100 100 111 111

Thanks.

--
 Sergey

Wednesday, June 20, 2007, 3:21:25 PM, wrote:

JW> Say you have the following values for BBB:

JW> 1 2 3 10 20 30 50 70 80 80 90 100 101 110 110 120 120 150 190 200

JW> How is an index going to help you with BBB <> 100 ?
JW> You have to do a full table scan whether or not the column is indexed.




-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------