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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.