Optimizer and Query
Create Stat Table
Index Materialized View
Oracle Handling Invalidation
Understanding Domain Indexing
Create Reverse Index
Oracle Descending Index
Index Organized Tables
index Organized Table
Data Dictionary Views
Advanced Queuing Data
Rebuilding Defragmenting Indexes Online- Exercise
Rebuilding and defragmenting indexes online
Course project: Rebuilding an index online
Rebuild the descending index you created and leave the table online.
This exercise is worth 10 points.
In this exercise, you will rebuild the descending index you created in the previous exercise because many new rows have been added to the table and many rows representing older sales have been deleted. You want the
table to remain available while you rebuild the index.
Review the fact file to find out more information about the House-O-Pets and its Oracle database. Click the View Tables link below to see the contents of the tables in the House-O-Pets database.
View Tables Link
You can download a correct version of the script for this exercise, descindreb.sql, from the Resources page.
You have seen the performance of the descending index that you built for the House-O-Pets Sales Department decrease over time. You want to see whether rebuilding the index will improve the performance of the index, but you don't want to have to disrupt the use of the index while it is being rebuilt.
Write a script to rebuild the descending index
you built in the previous exercise.
The keyword to allow the table to remain online comes at the end of the SQL command.
Submitting your exercise
Type (or cut and paste) your plan into the box below to submit your answers . Click the
button when you are finished to submit the exercise. Remember to submit all of your answers at once.