Reorganizing Indexes
There are many ways to reorganize indexes. This section discusses the ones that will be both covered in the exam and will also be a big part of your life as a DBA.
Rebuilding Indexes
It is often necessary to rebuild indexes. This can happen for many reasons. The existing index may need to be moved to a different tablespace (it may have inadvertently gotten built in the wrong tablespace originally). The index may contain many deleted entries as can be the case if data older than the current month is deleted, and the date is one of the index columns. These deletions may leave holes in the index. Or an existing normal index needs to be converted to a reverse key index as might be the case when migrating applications from an ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
