Re: Does Oracle store values in indices? - Mailing list pgsql-hackers

From Denis Perchine
Subject Re: Does Oracle store values in indices?
Date
Msg-id 01012323562500.00614@dyp.perchine.com
Whole thread Raw
In response to Re: Does Oracle store values in indices?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Denis Perchine <dyp@perchine.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.

But how Oracle handles this?

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [GENERAL] MySQL -> Postgres dump converter
Next
From: Adam Haberlach
Date:
Subject: Re: [INTERFACES] Re: PHP and PostgreSQL