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
What are the 3 types of schema?
What is blocking and how would you troubleshoot it? : sql server database administration
What is normalization process?
System variable and temporary variables
How do I find information about the install locations for the various instances running on a computer?
What is clustered primary key?
Can the “if update (colname)” statement be used in a delete trigger?
What is sqlservr.exe - process - sql server (sqlex?press)?
What are relationships and mention different types of relationships in the dbms
What are .mdf files?
How to how to convert numeric expression data types using the convert() function??
How to get a list all databases on the sql server?
What is normalization? Explain its different types?
What is data set in report?
How to join two tables in a single query in ms sql server?