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 transaction server distributed transaction?

1034

What do you know about normalization and de- normalization?

916

Explain external key management in sql server 2008

877

Do you know how to send email from database?

981

What programming language would you use to create embedded functions in ssrs?

184

What is wide table?

942

Is BCNF better than 2NF & 3NF? Why?

1037

What is trigger and different types of Triggers?

1130

How to return the date part only from a sql server datetime datatype?

1092

What is difference between sql and sql server?

985

your distribution database is full what will u do

2167

How self join is different from outer join?

1103

What is bit data type?

1018

What is the concept of optimization?

1032

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1121