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 |
immad
Posting Yak Master
230 Posts |
Posted - 2015-04-15 : 11:00:50
|
hi,i have a question is index created on only primary key or it can be created on secondary key ?thanks for the answerimmad uddin ahmed |
|
MichaelJSQL
Constraint Violating Yak Guru
252 Posts |
Posted - 2015-04-15 : 11:03:05
|
By default , a clustered index is created on the primary key, but you can override that. You can create indexes on additional columns if needed. |
|
|
immad
Posting Yak Master
230 Posts |
Posted - 2015-04-16 : 01:49:21
|
quote: Originally posted by MichaelJSQL By default , a clustered index is created on the primary key, but you can override that. You can create indexes on additional columns if needed.
Thanksimmad uddin ahmed |
|
|
|
|
|