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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 is index created on primary key or secondary key ?

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 answer




immad 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.
Go to Top of Page

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.


Thanks

immad uddin ahmed
Go to Top of Page
   

- Advertisement -