Indexes are created on database tables for effective joins. But what if too many indexes are created?
Two reasons why too many indexes are bad -
1) While doing upserts/inserts, the indexes will need to be modified so performance gets impacted.
2) Indexes need extra space to be stored physically, so more indexes means more space.
Two reasons why too many indexes are bad -
1) While doing upserts/inserts, the indexes will need to be modified so performance gets impacted.
2) Indexes need extra space to be stored physically, so more indexes means more space.
Tags
SQL Functions
Thanks a lot for all putting together all these questions. This will really help me in clearing my technical interview.
ReplyDelete