Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement
- 3 Answers
- 8210 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is normalization of database?
What are the differences between lost updates and uncommitted dependencies?
What is normalization? Describe its different types.
How many types of functions are there in sql server?
What is the architecture of ms sql reporting service?
What is an identity?
Explain left outer join and right outer join?
What is sql server locking?
What is extent? Types of extents?
How to test a dml trigger in ms sql server?
what is the main function of a query parameter?
What are logical/boolean operations in ms sql server?
What is replication and database mirroring?
What is the difference between value type and reference type?
What are cascading parameters in ssrs reports?
