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

What is the difference between lock, block and deadlock? : sql server database administration

1025

What do you understand by triggers?

899

How to access the inserted record of an event?

1028

Can you name some of the dml commands in sql?

1010

What are the advantages of sql azure?

140

Explain what is sql server english query?

1029

In which tcp/ip port does sql server run? Can it be changed?

975

how can u get last observation in an unknown dataset ?

2422

What is resource governor?

954

Can we use custom code in ssrs?

1097

How do you size a resultset?

900

What is the difference between dropping a database and taking a database offline?

1151

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1103

How can a user-defined datatype be created?

974

How to connect a database with sql express.?

1046