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 are the characteristics of modern DBMS?
Describe the functionalities that views support.
Does server sql treat char as a variable-length or fixed-length column?
What are the benefits and tasks of object explorer? : sql server management studio
How can you insert null values in a column while inserting the data?
How to call a function from a stored procedure in SQL Server ?
What is a view in sql?
What are the different types of locks in the database?
What is linked report?
How to edit table in sql server 2017?
What is the benefit of normalization?
How to encrypt data between dialogs?
what are the critical issues you have resloved in your company
what is the information that can be stored inside a bit column? : Sql server database administration
What is cursors? And what are the different types of cursor?