Databases Reference
In-Depth Information
Execution plan for a single table hash cluster
For the single-table hash cluster, you can see the effect of the cluster in
Execution
Plan
. It shows
TABLE ACCESS HASH
, which is a very eficient way to look up
the value that we are searching for. Also, in the
Statistics
part of the preceding
screenshot, note the number of
db block gets
and
consistent gets
. These numbers
give an indication of the amount of I/O that takes place to return the results to you.
The less I/O that needs to be done, the query tends to be more scalable. This means
that more requests can be handled without affecting response time and throughput.