Using query statistics
The warehouse manager has a number of areas of responsibility. One of these areas is maintaining the responsiveness of the system even when the query profiles change over time. This can be achieved by gathering statistics on the queries being physically executed against the data warehouse, and deducing the appropriate summaries to speed up common […]