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

How to create view in stored procedure sql server?

1015

How to get the definition of a user defined function back?

1042

How to use union to merge outputs from two queries together in ms sql server?

1061

What are different types of join?

1305

Can we install sql server 2016 on windows 7?

1127

How to turn on the mssql api module in php?

1068

When to use null data driven subscription?

206

What is a collation in ms sql server?

1075

What is SQL Azure Federations?

112

Difference between Sql server reporting services and Crystal reports?

168

Explain how does the report manager work in ssrs?

951

What are joins in sql and what are the different types of joins?

1006

What do you mean by stored techniques? How would we use it?

1022

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1600

What is sql server 2000 work load governor?

1055