Re: About Access paths

From: Ioannis Theoharis <theohari(at)ics(dot)forth(dot)gr>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: About Access paths
Date: 2005-03-06 21:39:05
Message-ID: Pine.GSO.4.58.0503062334590.14398@ourania.ics.forth.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-03-06 21:41:17 Re: About Access paths
Previous Message Martijn van Oosterhout 2005-03-06 21:29:29 Re: About Access paths