If there is primary key in table clustered index created by default ,othe

When do you create cluster and noncluster index?

Question Posted / naren

Answer Posted / naren

If there is primary key in table clustered index created by
default ,other wise non cluster index created .

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain indexes disadvantages?

1137

What is update_statistics command?

1121

Does the unique constraint create an index?

1130

Name 3 ways to get an accurate count of the number of records in a table?

1084

Which data type columns are the best candidates for full-text indexing?

1022

When you use @@error and try-catch?

1086

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1107

What is nolock hint in sql server 2008

1178

How to create view in stored procedure sql server?

1053

Which sql server is best?

1047

Differentiate between mongodb vs. Sql server?

1140

what is a schema in sql server 2005? : Sql server database administration

1078

How do I clean up sql server transaction log?

1123

What do you mean by an execution plan? Why is it used?

1075

What is the purpose of sql profiler in sql server?

1065