Can we create clustered index on non primary key column

Answer Posted / surya prakash

Finally, i want to conclude by saying.

1. We can create Clustered Index on Non-Primary Key Columns
and this table should not contain any other column with
Primary Key.

2. It is recommended that we create Clustered Indexing on
Primary Key Columns

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between getdate and sysdatetime in sql server 2008?

815


Does the order of columns in update statements matter?

689


What is transact-sql language?

789


Write a SQL query to make a column as unique?

803


Do you know exporting and importing utility?

727


What is 4nf in normalization form?

775


How do you trace the traffic hitting a sql server?

843


What are 3 ways to get a count of the number of records in a table?

859


Does union all remove duplicates?

842


Do you know what are acid properties?

797


What are alternate keys?

765


What is a synonym for manipulation?

752


What are page splits? : SQL Server Architecture

768


How to generate create procedure script on an existing stored procedure?

728


What is indexing a document?

747