Skip site navigation (1) Skip section navigation (2)

Re: Covering Indexes

From: Thomas Munro <munro(at)ip9(dot)org>
To: Rob Wultsch <wultsch(at)gmail(dot)com>
Cc: "David E(dot) Wheeler" <david(at)justatheory(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Covering Indexes
Date: 2012-06-30 10:12:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On 28 June 2012 14:02, Rob Wultsch <wultsch(at)gmail(dot)com> wrote:
> On Thu, Jun 28, 2012 at 8:16 AM, David E. Wheeler <david(at)justatheory(dot)com> wrote:
>> I'm particularly intrigued by "covering indexes". For example:
>>    CREATE INDEX cover1 ON table1(a,b) COVERING(c,d);
> IRC MS SQL also allow unindexed columns in the index.

For what it's worth, DB2 also has this feature, written roughly the
same way as MS SQL Server: CREATE INDEX cover1 ON table1(a, b) INCLUDE
(c, d).

Oracle doesn't seem to have this feature (and the SQL standard doesn't
mention indexes at all).

In response to

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2012-06-30 10:44:04
Subject: Re: elog/ereport noreturn decoration
Previous:From: Andres FreundDate: 2012-06-30 09:51:31
Subject: XX000: enum value 117721 not found in cache for enum enumcrash

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group