Write Overhead
Indexes are not free; their maintenance cost must be weighed against the read speed they provide. Every index on a table must be updated whenever data is written, inserted, or deleted. Maintaining indexes adds overhead to write operations.
1 sources - 3 claims
Indexes are not free; their maintenance cost must be weighed against the read speed they provide. Every index on a table must be updated whenever data is written, inserted, or deleted. Maintaining indexes adds overhead to write operations.