Can we create clustered index on non primary key column
- 20 Answers
- 51429 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / laxman2610
Yes, But on that table primary key should be created with
non-clustered index and the columun u want to create a
cluster index is should be unique
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is query and its types?
What are cursors in ms sql server?
Differentiate between truncate vs delete in mssql?
What is a unique index?
Explain how you can configure a running aggregate in SSRS?
How do I get to sql server configuration manager?
How many types of keys are there?
What are the tool windows in sql server management studio? : sql server management studio
How do we know if any query is retrieving a large amount of data or very little data?
What are the elements of dbms?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Name few of the dcl commands in sql?
what protocol both networks use? : Sql server database administration
How to get the definition of a view out of the sql server?
How many types of attribute relationships are there? : sql server analysis services, ssas
