Covered Indexes

  • In SQL Server 2005 you can create covered indexes using the INCLUDE argument.  My question is this: Is this SQL Server 2005 specific feature or is it a SQL standard supported by such DBMS's as DB2, Oracle, etc?

     

  • Hi Lynn,

    The index column include is from Microsoft not ANSI, I think it is one of the best new features in SQL Server 2005 because it let you add columns to an index definition that may not qualify to be part of a key.  I call it implicit composite because it is not really a composite per ANSI SQL definition.  The vendors own the index subsystem so Microsoft tossed everything before 2005 and created a new infrastructure for 2005.

    http://msdn2.microsoft.com/en-us/library/ms190806.aspx

     

    Kind regards,
    Gift Peddie

  • That helps.  It means that products like PeopleSoft aren't going to update their tools to take advantage of non standard enhancements like the INCLUDEd columns in indexes in SQL Server 2005 unless other DBMS providers decide to do the same or it becomes an ANSI standard.

    Thanks

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply