I have a table with a bunch of data (in json). I want to search on several
values, each one is indexed. However, if I search for COND1 AND COND2, the
query plan is simply
SEARCH TABLE data USING INDEX cond1Index (cond1=?)
Is this normal? I was hoping it could use the indexes somehow for both
Should I be creating indexes differently to cover two dimensions at once?
Perhaps with r*tree?
sqlite-users mailing list