Can we create clustered index on non primary key column
- 20 Answers
- 51432 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / ashok
we can creta clustered index on non primary column.
create table abc(eid int,ename varchar(50))
create clustered index abc_clustered on abc (eid)
| Is This Answer Correct ? | 67 Yes | 9 No |
Post New Answer View All Answers
What is a partition key?
What is query parameter in ssrs?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is onf in normalization form?
Is it possible to create trigger on views?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How to use wildcard characters in like operations in ms sql server?
How to insert multiple rows with one insert statement in ms sql server?
What is the bookmark lookup and rid lookup?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Explain about system stored procedure?
What is for xml in sql server?
What is cursors?
What is de-normalization and what are some of the examples of it?
What is exclusive locks?
