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

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

Column

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.
Parent Topic: System Catalogs