On 28 June 2012 14:02, Rob Wultsch <wult...@gmail.com> wrote:
> On Thu, Jun 28, 2012 at 8:16 AM, David E. Wheeler <da...@justatheory.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).

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to