Thomas Briggs wrote:
I think the common misconception is that indexes on multiple individual columns can be used in conjunction with one another, which isn't the case (unless you're talking about bitmap indexes, but since SQLite doesn't have those, we clearly aren't :P). Once you get comfortable with the fact that only a single index can be used everything makes sense.
Just to be clear, you mean a single index per table, right? Two tables in a where can use two indices in sqlite?
-- Ted Unangst www.coverity.com Coverity, Inc.
