On 8/9/2017 10:50 AM, Wout Mertens wrote:
in experimenting with indexes I found that if you create an index on (a, b)
and then SELECT * FROM data WHERE a = 1 AND B = 2, it will use the index,
great.
However, if you write SELECT * FROM data WHERE a = 1, it won't use the
index.
Are you sure? How do you determine that? My experience is different.
Case in point, I have an app that allows searching across 4 of parameters,
and I am wondering if I could just use a single 4-valued index
If you have an index on (a, b, c, d), it'll help for conditions like "a=1" or "a=1 and b=2" or "a=1 and b=2 and
c=3" - conditions that use a prefix on an index. But it won't help with "b=2" or "c=3" or "b=2 and c=3".
Think of it this way. Imagine you have a phone book, with entries sorted by last name and
then first name. In this book, it's easy to find people named "Smith, John", or
all people with last name of Smith - but it won't at all help to find all people with
first name of John.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users