© Darl Kuhn, Sam R. Alapati and Bill Padfield 2016

Darl Kuhn, Sam R Alapati and Bill Padfield, Expert Oracle Indexing and Access Paths, 10.1007/978-1-4842-1984-3_6

6. Partitioned Indexes

Darl Kuhn, Sam R. Alapati2 and Bill Padfield3

(1)Morrison, Colorado, USA

(2)Flower Mound, Texas, USA

(3)Aurora, Colorado, USA

If you use partitioned tables as part of your application, it is likely, if not imperative, that you use partitioned indexes to complement the advantages gained by using table partitioning. Usually, having partitioned table and indexes go hand in hand—when there’s one, there’s usually both. This is common, but not essential. It is possible to have partitioned tables without partitioned indexes, and it is possible to have a non-partitioned table ...

Get Expert Oracle Indexing and Access Paths: 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.