My Oracle Support Banner

RDBPROD: Using Query Outlines (Doc ID 1161084.1)

Last updated on APRIL 16, 2024

Applies to:

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

Purpose

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

Scope

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.

Details

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
Purpose
Scope
Details
 Query Outline Overview
 Simple Example
 Named Outlines
 Alternate Outline IDs
 Query Outlines for Triggers and Constraints
 Partial Outlines for Views and Column Expression
References

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