Lesson 13 - Managing Indexes

08/15/1999


Click here to start


Table of Contents

Managing Indexes

Objectives

Classification of Indexes

B-Tree Index

Reverse Key Index

Bitmap Index

Comparing B-Tree and Bitmap Indexes

Creating Normal B-Tree Indexes

Creating Indexes: Guidelines

Creating Reverse Key Indexes

Creating Bitmap Indexes

Changing Storage Parameters for Indexes

Allocating and Deallocating Index Space

Rebuilding Indexes

Checking Index Validity

Dropping Indexes

Obtaining Index Information

Summary

Author: Oracle

Email: melody@ecst.csuchico.edu

Home Page: http://www.ecst.csuchico.edu/~melody

Download presentation source