Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement
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 |
Post New Answer View All Answers
How to create view in stored procedure sql server?
How to get the definition of a user defined function back?
How to use union to merge outputs from two queries together in ms sql server?
What are different types of join?
Can we install sql server 2016 on windows 7?
How to turn on the mssql api module in php?
When to use null data driven subscription?
What is a collation in ms sql server?
What is SQL Azure Federations?
Difference between Sql server reporting services and Crystal reports?
Explain how does the report manager work in ssrs?
What are joins in sql and what are the different types of joins?
What do you mean by stored techniques? How would we use it?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What is sql server 2000 work load governor?