Help Center/ Data Warehouse Service/ Developer Guide/ Developer Guide (9.1.1.x)/ DWS System Catalogs and Views/ System Catalogs/ SQL_OUTLINE
Updated on 2026-01-04 GMT+08:00
View PDF
Share

SQL_OUTLINE

SQL_OUTLINE records statement plan information. After planmgmt_options is set, sql_hash and plan_hash are generated for statements that meet conditions and plans are saved to this system catalog.

  • This system catalog's schema is dbms_om.
  • This system catalog cannot be modified or deleted externally. Otherwise, functions related to plan management may be abnormal.
  • The system catalog cannot clear itself automatically. When you enable auto-extracting and saving outlines through plan management, monitor the catalog's usage carefully. This prevents cluster issues due to high space consumption.
Table 1 SQL_OUTLINE columns

Name

Type

Description

outine_name

text

Name of an outline. The value starts with outline_.

sql_hash

text

sql_hash of the actual SQL statement that generates the plan. The value starts with sql_.

plan_hash

text

plan_hash of the plan. The value starts with plan_.

create_time

timestamp with time zone

Time when the outline is generated

outline_version

numeric

Version number of the outline.

NOTE:

The supported hint types vary depending on the outline version. The details are as follows:

  • 821.001: hints in join order, join mode, and scan mode are supported.
  • 821.002: Based on 821.001, stream hints (excluding AGG redistribution key hints) are added.
  • 910.001: Based on 821.002, skew hints are added to support skew hint extraction in joins and aggregations.

outline

text

Outline string automatically generated by the plan.

cost

float8

Cost of the plan for generating the outline. This column is available only in clusters of version 9.1.1.200 or later.
Parent Topic: System Catalogs