Maintaining Indexes on Partitioned Tables

Having partitioned tables and indexes offer many advantages, but there are maintenance implications when creating partitioned tables and indexes that must be considered and taken into account when designing your application. The maintenance activities vary based on the circumstances and your specific application design and database design. For your specific application, this includes the DML patterns of your application and the volume of data that is being insert, updated, and deleted. DML activity is slowed by the presence of indexes. In some applications, particularly in the data warehouse arena, it is beneficial to perform partition-level operations in order to speed up the overall application processing ...

Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database 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.