clustered & nonclustered indexes

[OhioSteve]

The book says that clustered indexes change the actual order of the records, nonclustered indexes do not change the actual order. Also, nonclustered indexes are separate items. Here are my questions:

1) Is it possible to have more than one clustered index of the same table? I would guess no.

2) How do you make nonclustered indexes? I did not see an option on the wizard for that.

3) Where do the nonclustered indexes appear in the enterprise manager? For example, I see the icons for diagrams, tables, views, etc. I do not see one called "indexes".

 

[clapag22]

1. Nope.

2 & 3. In Enterprise Mgr, right click on the table you are working with and choose "Manage Indexes".

 

[orethos]

1) You are correct. Each table can have only 1 clustered index.

2) You can create Clustered /non clustered indexes by using the "Create Index" wizard (I beleive the clustered/non option is on the 3rd screen), or via the "Manage Index / Keys" screen of the table designer

3) You can view indexes in enterprise manager by right clicking on the table in question and selecting All Tasks -> Manage Indexes

-curt.