Denis Perchine <[EMAIL PROTECTED]> writes: > I think this question already was raised here, but... Why PostgreSQL > does not do this? What are the pros, and contros? The reason you have to visit the main table is that tuple validity status is only stored in the main table, not in each index. See prior discussions in the archives. regards, tom lane
- [HACKERS] Does Oracle store values in indices? Denis Perchine
- Re: [HACKERS] Does Oracle store values in indices? Tom Lane
- Re: [HACKERS] Does Oracle store values in indice... Denis Perchine
- RE: [HACKERS] Does Oracle store values in indices? Mikheev, Vadim
- Re: [HACKERS] Does Oracle store values in indice... Denis Perchine
- Re: [HACKERS] Does Oracle store values in in... Bruce Momjian
- Re: [HACKERS] Does Oracle store values i... Alfred Perlstein
- RE: [HACKERS] Does Oracle store values in indices? Mikheev, Vadim