complexitydatabasessql
an index has a write cost too
Anonymous
An index can reduce rows examined for selective queries, but it uses storage and adds work to writes. Check the query shape and data distribution; indexing every column can add maintenance with little benefit.
0