Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54892 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / gunjan sapra
no,we can't create clustered index on non primary key just
because of the simple reason that in clstered
index,physical sorting is done while in non primary key
there might be hundreds of duplicate entries. so, if we
create clusterd index on non primary key it will get
confused and then error.
| Is This Answer Correct ? | 34 Yes | 49 No |
Post New Answer View All Answers
What should be the fill factor for indexes created on tables? : sql server database administration
How to trouble shoot if unable to connect SQL Server
What is normalization of database? What are its benefits?
Is sql server difficult to learn?
What is difference between inner join and full join?
How to enter binary string literals in ms sql server?
What is in place upgrade in sql server?
what is difference between view and Dip.
how many layers of tcp/ip protocol combined of? : Sql server database administration
What is a not null constraint?
Who is the owner of a schema in ms sql server?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What do you understand by the analysis services in sql server?
what are constraints? : Sql server database administration
Does sql server 2016 have ssms?
