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 types of subqueries?
What is dml command?
Define tempdb database?
How and why use sql server?
How do you debug a procedure in sql server?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Does the order of columns in update statements matter?
Can binary strings be converted into numeric or float data types?
What is collation?
What is a group function explain with an example?
What do you understand by replication in sql server?
How can you manage sql azure security?
What is the function of sql server agent windows service?
What is sql server transaction log file?
What is a self join in sql server?