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

What is a cache in ssrs?

138

What is a trigger what are the advantages of trigger?

1062

How do I open a .db file?

1080

What is the default schema of your login session in ms sql server?

1090

Explain subquery and state its properties?

1087

Please differentiate between a local and a global temporary table?

1056

Define right outer join in sql server joins?

1106

What is scrollable cursor?

1080

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1242

How to copy the tables, schema and views from one sql server to another?

1098

Write a SQL command to insert and update only a particular field?

1187

What is openxml in sql server?

1219

What is clustered vs nonclustered index?

998

Write a program using SQL queries to find a unique entry in a table.

1043

Where views are stored in sql server?

1026