Non-clustered index. Important thing to note: By default a clustered inde

Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement

Question Posted / rams

Answer Posted / rams

Non-clustered index. Important thing to note: By default a
clustered index gets created on the primary key, unless
specified otherwise.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What to check if a User database is locked?

1030

Can a trigger be created on a view?

906

What is an execution plan?

1074

what is normalization? Explain different levels of normalization? : Sql server database administration

1235

What is primary key index?

926

Do you know how to implement service broker?

893

Does partitioning help performance?

896

Do you know the cursor types?

1124

Determine when to use stored procedure to complete sql server tasks?

1002

Difference between Inner vs outer joins?

906

Explain transaction server distributed transaction?

937

How to insert a new row into a table with "insert into" statements in ms sql server?

922

Is natural join and equi join same?

921

Define right outer join in sql server joins?

995

Does sql server 2000 full-text search support clustering?

827