Tim Romano <tim.romano...@gmail.com> wrote: > How would you find a row whose column X contained value Y if the "partial" > index on column X specified that rows containing value Y in column X should > never be returned?
No one suggests partial index should be capable of hiding anything. The idea is that, when the query can be proven to only involve rows covered by the partial index, the index can be used to speed up the query. Otherwise, it simply won't be used. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users