Can we create clustered index on non primary key column

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


Please Help Members By Posting Answers For Below Questions

When would you use a before or after trigger?

698


How real and float literal values are rounded?

850


What is triggers in ms sql server?

830


What are the High-Availability solutions in SQL Server and differentiate them briefly?

927


How to optimize stored procedures in sql server?

884


What is table level trigger?

790


What are the steps you will take to improve the performance of a poor performing query?

786


What are the disadvantages of indexes?

728


what is the difference between Tabular and Matrix report?

146


What is full outer join in sql server joins?

759


What is indexing in sql server with example?

728


How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

956


How do I setup a sql server database?

790


Tell me what is de-normalization and what are some of the examples of it?

792


Explain the difference between cross join and full outer join?

699