Table of ContentsUsing Clusters and Index-Organized Tables Objectives Distribution of Rows Within a Table Clusters Cluster Types Creating Index Clusters Creating Index Clusters Creating Hash Clusters Defining SIZE for Clusters Parameters Specific to Hash Clusters Altering Clusters Dropping Clusters Situations Where Clusters Are Useful Retrieving Cluster Information Index-Organized Tables Index-Organized Tables Compared with Regular Tables Creating Index-Organized Tables Row Overflow Retrieving IOT Information from Data Dictionary Summary |
Author: Oracle Email: melody@ecst.csuchico.edu Home Page: http://www.ecst.csuchico.edu/~melody |