Chapter 10. Tuning Query Performance
Query performance tuning is an ongoing process, which is needed throughout the life cycle of any database application. A data warehouse is no exception, and, in fact, good query performance is extremely crucial to the success of any data warehouse. It is important when the application is first designed that the SQL statements are well written and all requisite access structures, such as indexes and materialized views, are created to obtain good execution plans. However, even after the application is deployed, as the data and query workload changes, you will find that you will need to tune the SQL and modify the access structures periodically in order to meet your performance goals.
There are many different reasons ...
Get Oracle 10g Data Warehousing now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
