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

How do I find the sql server database version?

1054

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

187

How do I perform an unattended install of sql server 2000?

1138

If user is owning any SQL Objects, can we drop that user

2133

How to backup SQL Server Reporting Services ?

152

What does asynchronous call backs means?

1232

Where can you find the error log information? : sql server database administration

1072

What are cursors stored procedures and triggers?

1083

Why I have to use stored procedures?

1096

List the different types of collation sensitivities in sql server?

1078

Write a program to fetch first 10 records from a file?

1063

Explain what is raid and what are different types of raid levels?

1091

What command must you use to include the not null constraint after a table has already been created?

1234

Call by value and call by reference in procedure and function, with NOCOPY.

1349

Define ACID properties in a Database?

1104