What is a partitioned index?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a partitioned index?
Rating:
A partitioned index is an index that is broken down into smaller and more manageable pieces called partitions. Partitioning an index reduces the disk contention for index lookup and enhances the performance and scalability. Each partition of a partitioned index is allocated a segment. All partitions of a partitioned index share the same logical attributes. However, they can have different physical attributes based on tablespaces in which they reside.
Rating:
Was this information helpful?
Other articles
- How to create a report?
- What is a segment?
- What is SSAS?
- What is FILLFACTOR?
- How is a constraint enabled?