What is one drawback of creating too many indexes on a table…
What is one drawback of creating too many indexes on a table? Queries will return incorrect results Table updates (INSERT, UPDATE, DELETE) will become slower It reduces the number of rows that can be stored in the table It disables the ability to use WHERE clauses Answer: Table updates (INSERT, UPDATE, DELETE) will become slower Explanation: Each index must also be updated when rows change, which slows modifications. Indexes don’t change query correctness, storage row limits, or WHERE clause functionality.