[dba-SQLServer] Indexes Question

Arthur,

Just curious, why do you keep asking the same question under different
subject-lines?
You asked this question in slightly different manners under the subject
"Covering Indexes", and "Pointless Indexes" - I answered both, but you
didn't respond. Now the question reappears as "Index Question". Why not
stick to the original thread and let people know if answers given are useful
for you?

Asger

-----Oprindelig meddelelse-----
Fra: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Arthur
Fuller
Sendt: 13. august 2008 14:55
Til: Discussion concerning MS SQL Server
Emne: [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