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


Please Help Members By Posting Answers For Below Questions

What are the characteristics of modern DBMS?

700


Describe the functionalities that views support.

744


Does server sql treat char as a variable-length or fixed-length column?

684


What are the benefits and tasks of object explorer? : sql server management studio

705


How can you insert null values in a column while inserting the data?

811






How to call a function from a stored procedure in SQL Server ?

643


What is a view in sql?

664


What are the different types of locks in the database?

559


What is linked report?

93


How to edit table in sql server 2017?

607


What is the benefit of normalization?

687


How to encrypt data between dialogs?

663


what are the critical issues you have resloved in your company

1633


what is the information that can be stored inside a bit column? : Sql server database administration

600


What is cursors? And what are the different types of cursor?

649