Re: About Access paths - Mailing list pgsql-general

From Ioannis Theoharis
Subject Re: About Access paths
Date
Msg-id Pine.GSO.4.58.0503062334590.14398@ourania.ics.forth.gr
Whole thread Raw
In response to Re: About Access paths  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: About Access paths
List 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: About Access paths
Next
From: Martijn van Oosterhout
Date:
Subject: Re: About Access paths