What Are The Tradeoffs Between Many Vs Few Indexes? When Would You Wa

1.	What Are The Tradeoffs Between Many Vs Few Indexes? When Would You Want To Have Many, And When Would It Be Better To Have Fewer?
Answer» Fewer INDEXES on a table mean FASTER inserts/updates. More indexes mean faster, more specific WHERE clauses possibly WITHOUT index MERGES. Fewer indexes on a table mean faster inserts/updates. More indexes mean faster, more specific WHERE clauses possibly without index merges.

What Are The Tradeoffs Between Many Vs Few Indexes? When Would You Want To Have Many, And When Would It Be Better To Have Fewer?

Answer»

Fewer INDEXES on a table mean FASTER inserts/updates. More indexes mean faster, more specific WHERE clauses possibly WITHOUT index MERGES.

Fewer indexes on a table mean faster inserts/updates. More indexes mean faster, more specific WHERE clauses possibly without index merges.