SQLite Forum

INDEX usage on inequality and IN
Ok understand, but suppose you have 1.000.000 records and only 4 possible values for type. So basically you have 25% of type=1 25% type=2 and so on...
So if I have an index on type and I do WHERE type!=1 the index can help me to skip 25% of records, is it correct?
Otherwise how can I rewrite my query to benefit from index?