When do u use clustered index and non-clustered index?
Answer Posted / chethan nagaraj
Clustered index is faster when there is selecting a range
of values while the non clustering index is useful when
there is a modification(DML),
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is 4nf in normalization form?
What does it mean to normalize a database and why would you do it?
How to write character string constants or literals in ms sql server?
Explain external key management in sql server 2008
What is difference between drop truncate and delete?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
When a primary key constraint is included in a table, what other constraints does this imply?
What is bulkcopy in sql?
What is the impact on other user sessions when creating indexes?
Explain about SQLOS?
How do I start sql server agent automatically?
What does set rowcount do?
Explain linked server in sql?
State a few properties of relational databases?
Where are SQL server users names and passwords are stored in sql server?