You only do that to databases that have billions and trillions of rows. It's not like you have to do that until you start to feel the processor screaming.

Disclaimer: Of course, this is different for every single scenario.