This would significantly improve use of the library. Establish lines of communication between the power users and the person responsible for data warehouse performance. The power users would indicate the intention for access to new data or to data in a different access pattern. This would give the person assigned to data warehouse performance time to estimate the impact of the new query and determine if anything should be done even before it is run for the first time. DBMS systems have a variety of tuning knobs, choices for sizes and numbers of pools, initialization parameters, free space management, indexes, partitioning, disk configuration and data set placement that will have a marked impact on performance.
Most large organizations have people or even whole departments devoted to controlling performance.
They are responsible for estimating performance, capacity planning, monitoring performance and tuning and correcting the problems. They work closely with other members of the organization who are directly responsible for the system, the database and the network. Some of these organizations are now focusing on the performance of the data warehouse. A healthy data warehouse can remain healthy, but only if IT takes proactive steps to monitor, measure and tune the data warehouse databases. Sid Adelman is a consultant specializing in data warehouse and strategic data architecture.