DB Index

Question 1

What are pros and cons on an index?

Answer 1

Pros: The goal of creating an index on a table in a database is to make it faster to search through the table and find the row or rows that we want.
Cons:o The downside is that indexes make it slower to add rows or make updates to existing rows for that table since we not only have to write the data but also have to update the index.

Question 2

What is the difference between clustered ineex, unclustered index and heap ?

Answer 2

Just read the file if you don’t remmber