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 to create a simple user defined function in ms sql server?

1027

What are the key configuration files for sql server reporting services ?

169

Why use identity in sql server?

1110

What are the properties of the relational tables?

881

Explain raiserror in sql server?

1031

What is parameterized reports in ssrs ?

149

What is indexing a document?

1034

What is snapshot parameter in ssrs?

150

What are scalar functions?

1002

What are the requirements to use odbc connections in php scripts?

1121

What is update_statistics command?

1070

How is foreign key related to primary key?

972

Write a SQL queries on Self Join and Inner Join.

1048

What are cursors in ms sql server?

1183

How to encrypt data between dialogs?

1114