When do you create cluster and noncluster index?
Answer Posted / jerry joseph
A table can have 1 clustered index and 249 non-clustered indexes
indexes make sorting efficient
generally clustered index is ideal for the Primary Key
non-clustered indexes are ideal for columns which are used
in sorting (the columns in OrderBy)
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between Triggers and Stored Procedure?
What is 2nf normalization?
How to write a query with an inner join in ms sql server?
How can we remove orphan records from a table?
What are the disadvantages of indexes?
What do you understand by mirroring?
what is database replicaion? : Sql server database administration
What do you mean by collation recursive stored procedure?
Do you know what is replace and stuff function in sql server?
What are the different types of indexes?
What is the difference between rank and dense_rank?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is normalization? Describe its different types.
What is the difference between DATETIME2 and DATETIME?
Why de-normalization required?