3-2.模式对象管理(索引).docVIP

SRC: Oracle8i Administrator’s Guide(14) Managing Indexes Guidelines for Managing Indexes Creating Indexes Altering Indexes Monitoring Space Use of Indexes Dropping Indexes Guidelines for Managing Indexes Oracle provides several indexing schemes: B*-tree indexes (currently the most common) B*-tree cluster indexes hash cluster indexes reverse key indexes bitmap indexes function-based indexes domain indexes Indexes are logically and physically independent of the data in the associated table. Oracle automatically reflects changes to data, such as adding new rows, updating rows, or deleting rows, i