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

How do we Backup SQL Azure Data?

108

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

1010

What is the difference between a clustered index and a non-clustered index?

983

Working with TLogs

1824

What are the main sources of data?

1082

What is view in sql?

894

Can foreign key be deleted?

914

What is the new security features added in sql server 2014? : sql server security

989

How to delete an existing row with delete statements in ms sql server?

1076

Can we return Data from 4(more than 1) tables in stored procedure?

1046

Can a function call a stored procedure in sql server?

944

How do you check sql server is up and running?

981

Can you create a logon trigger in sql server 2005 express edition?

1072

Can an entity have two primary keys?

973

How will you optimize a stored procedure optimization?

1022