Composite Index Question

[jfrost10]

Hey guys,

My MCSE book mentions that if you have a table with one clustered index and the rest of the columns have nonclustered, its said to be "covered"

Well, if I had a table with 5 columns, 1 clustered and 2 nonclustered, would it still be considered composite/"covered", or does that only apply to indexes that cover the ENTIRE table so the table never actually gets accessed in queries?

Sorry if thats wrong; thats how I read the book, and just need some clarification


thanks,

D'Arcy

 

[jfrost10]

Sorry guys, one other thing I need clarification on:

the northwind's customer table has a non-clustered index for each column except for the pk, which is clustered.

Now, in the book, I create anotehr index called Contacts which includes the contact, city, country, and phone columns.

Now, does that mean then that the index that is created has a listing of RID's with all the contact, city, country and phone column information?! That many indexes just seems like an aweful lot of duplication (maybe I'm getting confused, but it sounds like indexes hold info almost like a view does, but made for querying instead?). ARe they just showing me the example for example sake and not a real world situation?

thanks again,

D