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 / swapna

Answer Posted / swapna

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 ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can a database be repaired?

986

How to delete exactly duplicate records from a table?

1061

Can we use where and having clause together?

1038

How do you drop an index?

917

Explain the types of indexes.

1207

Can we install sql server 2016 on windows 7?

1128

What is table-valued sub query?

958

What is analysis service repository?

1023

What is openrowset sql server?

1125

What are views in ms sql server?

1076

What is Service Broker in sql server 2012?

1018

what is raid and what are different types of raid configurations? : Sql server database administration

1032

Can we call future method from queueable?

1041

What is usually the first word in a sql query?

1128

How to download and install the scaled-down database adventureworkslt?

988