Can we create clustered index on non primary key column

Answer Posted / vikas kant

Yes We can create clustered index on a non primary key
column by using the following syntax--:

create clustered index abc_index on Table1(student_class)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write query to return all rows sql?

843


Tell me when is the update_statistics command used?

764


Difference between LEN() and DATALENGTH() in sql server ?

865


When you use @@error and try-catch?

809


Write a query for primary key constraint with identity key word?

809


What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

778


How raid can influence database performance?

797


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1108


What is nolock?

777


Can group functions be used in the order by clause in ms sql server?

792


explain what is raid and what are different types of raid configurations? : Sql server database administration

766


What command is used to create a database in the sql server and how?

894


What are the different types of lock modes in sql server 2000?

676


What is sql azure database?

198


List down some advantages of sql stored procedure?

748