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
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 Eisentraut||Date: 2012-06-30 10:44:04|
|Subject: Re: elog/ereport noreturn decoration|
|Previous:||From: Andres Freund||Date: 2012-06-30 09:51:31|
|Subject: XX000: enum value 117721 not found in cache for enum enumcrash|