whenever you create index without specifying the type, its non-clustered.

Which index created when Create Index on table(col), Why

Question Posted / sanjay

Answer Posted / sanjay

whenever you create index without specifying the type, its
non-clustered.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

In which files does sql server actually store data?

846

How to fetch the next row from a cursor with a "fetch" statement?

1015

What is a self join in sql server?

1050

What are the different types of data sources in ssrs?

186

Why use view instead of a table?

878

How we can refresh the view?

1055

What is the difference between a check constraint and a rule?

1128

Can you import Microsoft Excel data to SSRS?

123

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

842

Explain go command in sql server?

963

What is the importance of three tier architecture?

1025

How to enable tcp/ip protocol on a sql server?

1090

What is the difference between clustered index and primary key?

867

What is normalization and its types?

959

What is filtered index?

1038