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 is difference between foreign key and unique key?

960

How to use linked server?

1080

What is side by side migration in sql server?

1017

How to delete duplicate rows from table except one?

930

Will the writetext statement activate a trigger?

995

Where is localdb stored?

884

Is the order of columns in the set clause important in ms sql server?

925

Explain identity in sql server?

948

What are pages and extents? : SQL Server Architecture

953

How to stop log file growing too big?

952

SQL Server Architecture ?

2396

What is normalization according to you and explain its different levels?

894

How to list all field names in the result set using mssql_field_name()?

867

How self join is different from outer join?

1058

Explain how to integrate the ssrs reports in application?

942