RSS Feed

Method R Discussion Group

How will stored outline play a role here?  I was referring to Data Warehousing and BO question where you cannot place hint in SQL statement.

Storing the outline (i.e., execution plan) for a SQL statement works only for a SQL statement that "matches" the text of the statement used to create the outline.

As long as stored outlines are enabled and the stored execution plan is still valid, then the stored execution plan will be used for the execution of any matching SQL statement.

If the program, any program, responsible for generating SQL statements is stable (i.e., it always generates the same SQL text given the same inputs), then stored outlines should be effective.

Even if the program doesn't use bind variables, you can still take advantage of stored outlines by setting the parameter cursor_sharing to "force".