Martin Reid
mwp.reid at qub.ac.uk
Wed Aug 13 08:04:09 CDT 2008
Hi Arthur http://msdn.microsoft.com/en-us/library/ms190806.aspx Martin Martin WP Reid Information Services Queen's University Riddel Hall 185 Stranmillis Road Belfast BT9 5EE Tel : 02890974465 Email : mwp.reid at qub.ac.uk ________________________________________ From: dba-sqlserver-bounces at databaseadvisors.com [dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller [fuller.artful at gmail.com] Sent: 13 August 2008 13:55 To: Discussion concerning MS SQL Server Subject: [dba-SQLServer] Indexes Question In SQL you can create a compound index and you can also create included columns, and you can do both. What is the difference between them? When should a column be part of the index key and when should it be an included column? Is there any point to including a bit column in a compound index? TIA, Arthur _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com