Re: Does Oracle store values in indices?

Поиск
Список
Период
Сортировка
От Denis Perchine
Тема Re: Does Oracle store values in indices?
Дата
Msg-id 01012323562500.00614@dyp.perchine.com
обсуждение исходный текст
Ответ на Re: Does Oracle store values in indices?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: [GENERAL] MySQL -> Postgres dump converter
Следующее
От: Adam Haberlach
Дата:
Сообщение: Re: [INTERFACES] Re: PHP and PostgreSQL