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

List the different normalization forms?

757


How to generate create view script on an existing view?

795


Explain the steps to use transact-sql cursor?

697


Write a SQL query to make a column as unique?

817


Explain user defined views?

779


What is format parameter in ssrs?

130


What are various aggregate functions that are available?

741


Does windows server 2016 come with sql server?

734


what information is maintained within the msdb database? : Sql server administration

745


When you should use a low fill factor?

769


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

892


Can we write ddl in trigger?

695


What does the on delete cascade option do?

802


What is an entity-relationship diagram (erd)?

871


Explain about nested stored procedure?

831