SQLite Forum

Another example is with LIKE operator
if you do 
WHERE LIKE 'TEST%'
explainer tells you will use index
WHERE NOT LIKE 'TEST%'
just scan table

but you could end up in an example like that in the NOT LIKE statement gives you less result than the first