what are the negative effects of index every column?
I understand indexing all column would be extremely costly on server space, but now days, space is cheap.
Assume space isn't an issue, is there any negative consequences from indexing every column in a table?
Is memory cheap? Because when you load those indexes into memory, which is required in order to read from them, they take up memory.
Are CPU and I/O cheap? Because when you add an index on every single column, every single modification requires maintenance on every index. So if you have a table with 10 indexes, and modify one row, this could be 10 or more writes. This is costly all around.