Re: Does Oracle store values in indices?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Denis Perchine <dyp(at)perchine(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Does Oracle store values in indices?
Date: 2001-01-23 17:56:19
Message-ID: 7124.980272579@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Denis Perchine <dyp(at)perchine(dot)com> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Denis Perchine 2001-01-23 17:56:25 Re: Does Oracle store values in indices?
Previous Message Ned Lilly 2001-01-23 17:38:13 Re: question