Re: MVCC and index-only read

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: m_lists(at)yahoo(dot)it
Cc: "Sam Mason" <sam(at)samason(dot)me(dot)uk>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: MVCC and index-only read
Date: 2008-11-18 19:15:38
Message-ID: 36e682920811181115pb3d3560y18f175d9e3e408db@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 18, 2008 at 2:02 PM, Scara Maccai <m_lists(at)yahoo(dot)it> wrote:
> SELECT A FROM myTAB where A <10000
>
> only uses the index (if there's an index defined for A) in Oracle.

Well, not exactly. That's called a "covered" index because the query
could be satisfied directly from the index (the attribute is covered
by the index). Oracle sometimes satisfies it with an index fast full
scan, but not always; it depends on the cost of other access methods
and/or what Oracle believes is currently in cache.

--
Jonah H. Harris, Senior DBA
myYearbook.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-11-18 19:26:55 Re: apparent deadlock
Previous Message Scara Maccai 2008-11-18 19:02:29 Re: MVCC and index-only read