Can we create clustered index on non primary key column
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 the function of sql server agent windows service?
Explain data warehousing in sql server?
What programming language would you use to create embedded functions in ssrs?
What are the 2 types of classifications of constraints in the sql server?
What can be used instead of trigger?
Mention what are the different types of ssrs reports?
How to invoke a trigger on demand?
What is nolock hint in sql server 2008
What are views in ms sql server?
Tell me what are cursors and when they are useful?
what are the new features introduced in sql server 2000? : Sql server database administration
How do I get to sql server configuration manager?
Explain what is lock escalation and what is its purpose?
Write a sql query to delete duplicate records from a table called table1
How to run queries with sql server management studio express?