Re: About Access paths

Поиск
Список
Период
Сортировка
От Ioannis Theoharis
Тема Re: About Access paths
Дата
Msg-id Pine.GSO.4.58.0503062334590.14398@ourania.ics.forth.gr
обсуждение исходный текст
Ответ на Re: About Access paths  (Martijn van Oosterhout <kleptog@svana.org>)
Ответы Re: About Access paths  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general

> >
> > As far as i can see, postgresql select a simple "INDEX SCAN using index"
> > on table.
>
> That's because the index does not hold all the information. So INDEX
> ONLY is impossible.
>

Thank you for your quick answer, but there is something a don't
understand:

the index holds all attributes' values (one index entry/one table entry).
Right?
given a query with only this attribute on SELECT clause, which is the
missing information, that do not exist in index?


В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: About Access paths
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: About Access paths