"Indexes which involve more than one column. Use composite indexes when two or more columns are best searched as a unit because of their logical relationship." (Karen Paulsell et al, "Sybase SQL Server: Performance and Tuning Guide", 1996)
"Has two or more columns as index key columns in the same table." (Owen Williams, "MCSE TestPrep: SQL Server 6.5 Design and Implementation", 1998)
"An index that uses more than one column in a table to index data." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)
[compound index:] "An index whose keys contain values derived from more than one data column." (Peter Gulutzan & Trudy Pelzer, "SQL Performance Tuning", 2002)
"An index that is created on two or more columns in a table." (Bob Bryla, "Oracle Database Foundations", 2004)
"Indexes that can be built on more than a single field." (Gavin Powell, "Beginning Database Design", 2006)
"An index that includes two or more fields." (Rod Stephens, "Beginning Database Design Solutions", 2008)
"An index that is composed of more than one column. Both clustered and nonclustered indexes can be created as composite indexes." (Darril Gibson, "MCITP SQL Server 2005 Database Developer All-in-One Exam Guide", 2008)
"An index that is made of two or more columns." (Robert D. Schneider & Darril Gibson, "Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies", 2008)
"An index that uses more than one column in a table to index data." (Microsoft, "SQL Server 2012 Glossary", 2012)
No comments:
Post a Comment