Abstract
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 with partitioned indexes. There are several factors that affect the design of the database tables and indexes, including the following.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Darl Kuhn, Sam R. Alapati and Bill Padfield
About this chapter
Cite this chapter
Kuhn, D., Alapati, S.R., Padfield, B. (2016). Partitioned Indexes. In: Expert Oracle Indexing and Access Paths. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1984-3_6
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1984-3_6
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1983-6
Online ISBN: 978-1-4842-1984-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books