What are the type of Indexes? which one is best, why?
- 6 Answers
- 8547 Views
- I also Faced
- E-Mail Answers
Answer Posted / jay vardhan singh
Cluster is faster then non cluster index.We can use only
one cluster index on one table and we can use more then one
non cluster index on one table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the different index configurations a table can have?
Explain what is use of dbcc commands?
What is difference between equi join and inner join?
How would you choose between a clustered and a non-clustered index?
What is an indice?
What is an identity column in insert statements?
You want to implement the many-to-many relationship while designing tables. How would you do it?
Explain foreign key in sql server?
Explain filtered indexes?
How can you list all the table constraints in a database?
What is the stuff?
How to find index size for each index on table?
difference between Clustered index and non clustered index ?
How to delete a database in ms sql server?
How do I uninstall sql server 2014?
