I agree, you don't want performance to suddenly degrade and then you have to find out why. This can be especially bad when this happens with many tables that sh

I agree, you don't want performance to suddenly degrade and then you have to find out why. This can be especially bad when this happens with many tables that should have indexes, and performance is sluggish, but not for any specific action. Add indexes appropriately is a best practice.