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

What is a trigger and its types?

926

How much space does sql server 2016 take?

908

What is bcp? When does it use?

866

What is use of except clause?

1036

How can change procedure in sql server?

981

What is database isolation in sql server? : sql server database administration

1012

Mention the different authentication modes in sql server.

958

What is difference between count (*) and count 1?

862

Explain primary key?

895

Does table partitioning improve performance?

899

Define Joins?

972

What is the difference between ddl and dml?

1002

Explain what is meant by replication of database?

956

What is sub query and its properties?

916

How can I create a new template for import ? : sql server management studio

1022