Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54768 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 are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
How to stop a loop early with break statements in ms sql server?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
Explain a differential backup?
What are “lock” hints?
Can you edit the .rdl code associated with a linked report?
What is the downside of using udf?
What is the command to change the recovery model?
What are the basic features of a trigger in ms sql server?
What is a print index?
What is 1nf 2nf?
Explain boyce and codd normal form(bcnf)?
How to connect to a sql server using odbc_connect()?
How many cores do I need for sql server 2016?
What is unique key constraint?
