> 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 > > The thing, that I don't get is: Why should the rows be hidden? If the index ist just used to cover some special values, it didn't hide others.
If you create an index on some columns, it didn't hide the other columns, or? Artur Reilin ---------------- sqlite.yuedream.de _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
