With the explosion of packaged solutions, e.g. SAP/R3® and PeopleSoft® etc., and their many-thousands of tables exploited by dynamic SQL, the ability of performance specialists to effectively tune the application or SQL becomes virtually impossible. Packaged vendors will always endeavor to provide a reasonable set of indexes for these products, but each site’s individual implementation and use of these tools can be quite different and thus require alternative indexes and very often far fewer. Such analysis is a time-consuming and daunting task since it requires you to review individual SQL of an application for predicate usage and simultaneously take business priorities into account.
Administration and development teams often lack the specific information they require to make such critical decisions.