ALTER OUTLINE

Purpose

You can use this statement to add bound outlines and throttling rules. This statement only supports outlines created by using SQL_TEXT.

Syntax

ALTER OUTLINE outline_name ADD stmt [ TO target_stmt]

Parameters

Examples

• Execute ALTER OUTLINE to add throttling rules.

  obclient> CREATE OUTLINE outline1 ON SELECT /*+max_concurrent(1)*/ * FROM tbl1 WHERE col1 =1
             AND col2 = 1;
  obclient> ALTER OUTLINE outline1 ADD SELECT /*+max_concurrent(1)*/ * FROM tbl1 WHERE col1 =1
             AND col2 = ?;
  obclient> ALTER OUTLINE outline1 ADD SELECT /*+max_concurrent(1)*/ * FROM tbl1 WHERE col1 =?
             AND col2 = 1;
  

• Execute ALTER OUTLINE to add an execution plan.

  obclient> CREATE OUTLINE outline2 ON SELECT /*+max_concurrent(1)*/ * FROM tbl1,tbl2
            WHERE tbl1.col1 = 1;
  obclient> ALTER OUTLINE outline2 ADD SELECT /*+use_nl(tbl2)*/ * FROM tbl1,tbl2
            WHERE tbl1.col1 = 1;
  

• Use ALTER OUTLINE to add an execution plan and a throttling rule.

  obclient> CREATE OUTLINE outline2 ON SELECT /*+ use_nl(tbl2) max_concurrent(1)*/ * FROM tbl1,tbl2
         WHERE tbl1.col1 = 1;
  obclient> ALTER OUTLINE outline2 ADD SELECT /*+ use_nl(tbl2) max_concurrent(1)*/ * FROM tbl1,tbl2
         WHERE tbl1.col1 = 1;
  

Considerations

• Only one execution plan can be specified for the same outline_name. If an execution plan has been specified by using the CREATE OUTLINE statement, you cannot add the execution plan by executing ALTER OUTLINE.

• When you execute the ALTER OUTLINE statement, outline_name and signature must match.