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?

Answers


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.


Need Your Help

How to use the Command Pattern with GWT?

java gwt command-pattern

I've been watching a video on implementing the command pattern in GWT, but I could use some help in understanding it. Specifically, the video talks about how the command pattern can be used to cach...