Optimizer and Query
Oracle Optimizer Functions
Using Stored Outlines
Create Stat Table
Monitoring DB Operations
What are materialized Views
Materialized View Syntax
Summary Data Joins
Index Materialized View
Oracle Handling Invalidation
Query Rewriting Conditions
Explain Plan Command
Index Types Review
Create Descending index
Oracle bitmapped Index
Create Reverse Index
Reverse Index Creation
Understanding Domain Indexing
Rebuilding Defragmenting indexes
Function Based indexing
Index Category Conclusion
Index Organized Tables
index Organized Table
Create IOT Ttable
Bridge Primary Keys
Create Secondary Indexes
IOT vs. Regular Tables
IOT Table Conclusion
What is Advanced Queuing
Data Dictionary Views
PL/SQL Applications for Queuing
Developing Advanced Queuing Apps
Developing PL/SQL Apps for Enqueuing
PL/SQL Propagation Functionality
Run Queuing Apps
Advanced Queuing Conclusion
Converting long to LOB
Creating Descending Index - Exercise
Course Project: Creating Descending index
Create a descending index.
This exercise is worth 10 points.
Background | Overview
In this exercise, you will create a descending index as part of your
database. This index will be based on the date a sale took place on, so that it can be used in queries requesting the most recent sale first.
Review the fact file to find out more information about the House-O-Pets and their its Oracle database.
Click the link below to see the contents of the tables in the House-O-Pets database.
View Petstore Tables
You can download a correct version of the script for this exercise, descind.sql, from the Resources page.
You have discovered that there is a frequent need in the House-O-Pets Sales Department for reports that display the most recent sales first. A descending index on the
column would provide this information in presorted order.
Write a script to create a descending index on the
column in the
table. You should give the index a name of
The keyword for defining a descending index comes at the end of the
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.
Remember to submit all of your answers at once.