Igor Tandetnik 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.
Right.
--
Eric A. Smith
Well then, let's go on. Sorry, there's nothing to go on to.
Let's digress.
-- Tim Pulju, Winter 2005
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
