Clustered index is faster when there is selecting a range of values while

When do u use clustered index and non-clustered index?

Question Posted / chethan nagaraj

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

Please Help Members By Posting Answers For Below Questions

Find first and last day of current month in sql server

1028

what is a self join? Explain it with an example? : Sql server database administration

953

How will you make an attribute not process? : sql server analysis services, ssas

1090

What are the dmvs?

1014

How to install sql server 2005 express edition?

1123

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1137

How can we call UDF(User Define Function) using C# code in ASP.net ?

6887

Why do we need different type of parameter?

1057

What is cube dimension? : sql server analysis services, ssas

1005

What is amo? : sql server analysis services, ssas

1089

What is indexed view?

980

What is the distinction amongst delete and truncate?

1071

Explain table valued parameters in sql server? Why tvp used?

1020

What do you understand by a view? What does the with check option clause for a view do?

1006

How to receive output values from stored procedures?

1146