[sqlite] Select from indexed table

[Davide Guidotti]

Hi!
I have sqlite version 3.1.3, and Suse 9.3.
i have a table (LOG) with about 500.000 records.  The column "result" is a 
indexed column, if i make the select "select * from LOG where (result ="OK") 
limit 10;" it takes over 24 second to access all Values, instead with "select 
* from LOG where (result ="OK" OR 0) limit 10;" only takes about 1 second. 
Why the " Or 0" improves the search?    

Thanks