SQLite Forum

A suboptimal solution - not using the index.
Actually, in my "real project" case from where I started the tests, the b field in most cases contains a number, but sometimes it contains a string. 

And only in these rare cases the fields a and b can be equal.