On Thu, Jan 27, 2011 at 2:32 PM, Igor Neyman <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
