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
Creating Secondary Index on Index Organized Table - Exercise
Course project: Creating a secondary index on an index-organized table
Navigate to installed products and answer questions about them.
In this exercise, you will add a secondary index to the index-organized table you created in the last exercise. The secondary index will based on the product ID.
Review the fact file to find out more information about the House-O-Pets and its Oracle database.
Click the link below to see the contents of the tables in the House-O-Pets database.
House O-Pets database
You can download a correct version of the script for this exercise, seciot.sql, from the Resources page.
You have discovered that some of the queries against the
table ask for the information returned to be sorted by product ID. You want to see if the performance of queries on the index-organized table you just created can be improved by adding a secondary index based on the product ID.
Create a secondary index on the index-organized table you created in the last exercise. This index will be based on the
column in the
The syntax for creating a secondary index is the same as a standard index.
This index will not be unique.
Submitting your exercise
Type (or cut and paste) your plan into the box below to submit your answers.
button when you are finished to submit the exercise.