Rebuild Descending Index Online
| Exercise |
Rebuilding an index online |
| Objective |
Rebuild the descending index while keeping the table available for DML |
Course Project Scenario
You previously created a descending index for the House-O-Pets Sales Department:
IDX_SALE_DATE_DESC. Over time, many new rows have been inserted and older sales rows deleted.
The index performance has degraded and you want to rebuild it to restore efficiency—but you must keep
the SALE_HEADER table available while the rebuild runs.
Background
In Oracle, index maintenance can be performed without taking the table offline. For this exercise, your script
should rebuild the existing descending index online so that normal application activity can continue.
Fact File
Review the House-O-Pets table structures and sample data:
View Tables
Instructions
Write the SQL statement needed to rebuild the descending index IDX_SALE_DATE_DESC online.
Your answer should be a single, executable statement (you may include a comment if needed).
Hint
The keyword that keeps the underlying table available appears at the end of the rebuild statement.
Submit Your Answer
Enter your SQL below and click Submit. Keep your submission focused on the rebuild statement.