My Oracle Support Banner

RDBPROD: Using Query Outlines (Doc ID 1161084.1)

Last updated on FEBRUARY 06, 2020

Applies to:

Oracle Rdb Server on OpenVMS - Version and later
HP OpenVMS Alpha
HP OpenVMS Itanium


This article describes the query outline feature of Oracle Rdb and some of its uses and options.


This is intended for DBAs and programmers responsible for SQL query performance.

NOTE: The data used below are not actual PRODUCTION or Customer Data, they are Oracle supplied sample tables/data.

They are being used ONLY to demonstrate the problem discussed in this note.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Query Outline Overview
 Simple Example
 Named Outlines
 Alternate Outline IDs
 Query Outlines for Triggers and Constraints
 Partial Outlines for Views and Column Expression

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.