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 ...
© 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 Kuhn1 , Sam R. Alapati2 and Bill Padfield3
(1)Morrison, Colorado, USA
(2)Flower Mound, Texas, USA
(3)Aurora, Colorado, USA
Get Expert Oracle Indexing and Access Paths: 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.
