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). http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.sql.ref.doc/doc/r0000919.html 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: http://www.postgresql.org/mailpref/pgsql-hackers
