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
Write query to return all rows sql?
Tell me when is the update_statistics command used?
Difference between LEN() and DATALENGTH() in sql server ?
When you use @@error and try-catch?
Write a query for primary key constraint with identity key word?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How raid can influence database performance?
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?
What is nolock?
Can group functions be used in the order by clause in ms sql server?
explain what is raid and what are different types of raid configurations? : Sql server database administration
What command is used to create a database in the sql server and how?
What are the different types of lock modes in sql server 2000?
What is sql azure database?
List down some advantages of sql stored procedure?