What is a hash cluster?
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 hash cluster?
Rating:
A hash cluster is a group of tables that share the same Oracle block for storing data. Unlike a conventional cluster that uses a cluster key for retrieving rows, a hash cluster uses a hashing algorithm for retrieving rows directly. Hence, a hash cluster is a more efficient mechanism as compared to a conventional cluster because it reduces the disk I/O required to access the rows corresponding to a query.
Rating:
Was this information helpful?
Other articles
- What is a Database Resource Manager (DRM)?
- What is a resource plan ?
- What is the function of AUTOTRACE utility?
- What does the PCTUSED parameter specify?
- What is high water mark?