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

How to specify the collation for a character data type in ms sql server?

559

What are key, name and value columns of an attribute? : sql server analysis services, ssas

576

What are policy management terms?

567

Why variables called the most powerful component of ssis?

597

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

539

Tell me about builtinadministrator?

564

How can you stop stored procedures from recompiling?

492

How to drop existing indexes in ms sql server?

593

Name 3 ways to get an accurate count of the number of records in a table?

577

Define Wed Edition in SQL Azure?

What is the benefit of normalization?

598

You want to implement the one-to-one relationship while designing tables. How would you do it?

537

What is the purpose of object explorer and its features? : sql server management studio

605

What is a result set object returned by odbc_exec()?

554

What is the security model used in sql server 2005?

514