SQLite Forum

Usage of suboptimum index
Login
Hi,

yes,

Relations_Index1: 0.0177s
Relations_Index2: 99.35s

Index2/Index1 = 5613!

Index1 must be the fastest because there is at most one match (the statistics are matching exactly in my case).

Regards,
Hartwig

PS: Is there also a possibility to enforce the order of the index usage?