On Thu, Jan 27, 2011 at 2:32 PM, Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote: >> On Oracle? Then how can it get the values it needs without >> having to hit the data store? > > It doesn't. > It does "INDEX UNIQUE SCAN" and then "TABLE ACCESS BY INDEX ROWID". Ahhh, ok. I thought Oracle used covering indexes by default. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
