Recent work has increased my awareness for Workload Managed in busy warehouses, so I read DB2 workload management with interest. And was chuckling whenI read this, because I can’t say I’ve never heard the following argument being brought forward in earnest!
Sometimes, it seems, you simply don’t want queries to finish too fast. Why? Because if you give great performance when the machine is lightly loaded, then business users might expect that performance too when the machine is heavily loaded and you can’t deliver it. Apparently, in some environments it’s better to never deliver great query performance than it is to do so only inconsistently.