When do u use clustered index and non-clustered index?
Answer Posted / pradeep
To increase the performance of database we can use clustered Index .It will be in sorted order and it is in the form of B tree structure and it won't accept nulls.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain a differential backup?
What is the need for indexing?
How to Sync Two SQL Azure Databases?
What is mapping schema?
Which database stores information about replication?
List out the differences between the clustered index and non-clustered index in sql server?
Define constraints and give an example of their use?
How to provide login information for a new odbc dsn?
Difference between uniqe index and uniqe constraint?
What are the rendering extensions of ssrs?
Explain raiserror in sql server?
What are the differences between DDL, DML and DCL in SQL?
State a few properties of relational databases?
List out the differences between global and local temp tables in sql server?
Does partitioning improve performance sql server?