Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-05 : 14:53:00
|
| Ali writes "I am curious to know if creating an index on a column(s) that is a primary key will improve performance. I am under the imporession that when you create a primary key constraint it creates a clustered index using the columns in that key. Is there any reason why you would want to or should index a primary key? Exactly how does SQL Server 2000 treat a primary key constraint?" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-05 : 15:00:43
|
| The constraint part of a primary key is maintaind via a unique index.If there is no clustered index on the table the PK will by default create a clusered index - but you can define it to be non-clustered.>> Is there any reason why you would want to or should index a primary key?It always has a unique index associated so no need for another one.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Key Constraints and Indexes