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

Does transparent data encryption provide encryption when transmitting data across the network?

998

Explain the usage of floor function in sql server.

926

What is the difference between varchar and varchar types?

1014

What is sql server profiler?

963

Define candidate key, alternate key, and composite key.

880

How do I find the transaction log size in sql server?

934

Is there any difference between the primary key and unique key?

967

What is the difference in accessing db between sql server vs sql azure?

174

Why should we go for stored procedures? Why not direct queries?

1041

Define Unique Key?

954

How do you delete a trigger?

928

Explain Normalization and DE normalization

1063

What are the acid properties?

958

Do you know what is xpath?

1016

What is auditing in sql server?

888