Can we create clustered index on non primary key column
- 20 Answers
- 51491 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / durgaprasad
no its not possible to place clustered index on non key
column once the table contains any one key column, bcoz key
column itself contains one clustered index based on that
data sorted in ascending order.if u place one more
clustered index how it is possible to arrange the data in
soreted order.
| Is This Answer Correct ? | 15 Yes | 29 No |
Post New Answer View All Answers
What is collation sensitivity?
Is the primary key column of a table an index in ms sql server?
Explain unique key in sql server?
Why main is user defined function?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Explain the etl (extraction, transformation, and loading)?
What is user-defined inline table-valued function?
Do you know sql server 2008 introduces automatic auditing?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
How to fine-tune reports?
What does ss stand for sexually?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is data source object?
Does index slows down insert statements?
What is sql view?
