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

Can we return Data from 4(more than 1) tables in stored procedure?

1105

What is buffer cash in sql server?

1203

What are parameterized reports?

204

Can we create clustered index on composite key?

1168

What is trace flag in sql server?

1078

What is transaction server isolation?

1092

Describe how to use linked server?

1076

What is table-valued sub query?

1026

What is the use of keyword with encryption.

1081

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1076

How to execute a sql statement using odbc_exec()?

1213

Explain what is it unwise to create wide clustered index keys?

1023

How you can minimize the deadlock situation?

1081

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

1037

Explain the working of sql privileges?

1143