oracle 11g管理篇

Creating an Index Associated with a Constraint........................................................................21-9 Creating a Large Index.................................................................................................................21-11 Creating an Index Online.............................................................................................................21-11 Creating a Function-Based Index................................................................................................21-11 Creating a Key-Compressed Index.............................................................................................21-12 Creating an Unusable Index........................................................................................................21-13 Creating an Invisible Index..........................................................................................................21-14 Altering Indexes..................................................................................................................................21-15 Altering Storage Characteristics of an Index.............................................................................21-16 Rebuilding an Existing Index......................................................................................................21-16 Making an Index Unusable..........................................................................................................21-17 Making an Index Invisible...........................................................................................................21-18 Renaming an Index.......................................................................................................................21-19 Monitoring Index Usage..............................................................................................................21-19 Monitoring Space Use of Indexes....................................................................................................21-20 Dropping Indexes................................................................................................................................21-20 Indexes Data Dictionary Views........................................................................................................21-21 22Managing Clusters

About Clusters.......................................................................................................................................22-1 Guidelines for Managing Clusters....................................................................................................22-2 Choose Appropriate Tables for the Cluster................................................................................22-3 Choose Appropriate Columns for the Cluster Key....................................................................22-3 Specify the Space Required by an Average Cluster Key and Its Associated Rows ..............22-3 Specify the Location of Each Cluster and Cluster Index Rows................................................22-4 Estimate Cluster Size and Set Storage Parameters.....................................................................22-4 Creating Clusters...................................................................................................................................22-4 Creating Clustered Tables..............................................................................................................22-5 Creating Cluster Indexes................................................................................................................22-5 Altering Clusters...................................................................................................................................22-6 Altering Clustered Tables..............................................................................................................22-6 Altering Cluster Indexes................................................................................................................22-7 Dropping Clusters.................................................................................................................................22-7 Dropping Clustered Tables............................................................................................................22-8 Dropping Cluster Indexes..............................................................................................................22-8 Clusters Data Dictionary Views.........................................................................................................22-8 23 Managing Hash Clusters

About Hash Clusters.............................................................................................................................23-1 When to Use Hash Clusters.................................................................................................................23-2 Situations Where Hashing Is Useful.............................................................................................23-2 Situations Where Hashing Is Not Advantageous......................................................................23-2 Creating Hash Clusters........................................................................................................................23-2 Creating a Sorted Hash Cluster.....................................................................................................23-3 Creating Single-Table Hash Clusters...........................................................................................23-6 Controlling Space Use Within a Hash Cluster............................................................................23-6 Estimating Size Required by Hash Clusters................................................................................23-8 xviii