Execution Plan image:
The WINDOW operation consists of a physical or logical set of rows used for calculating the result of an analytical function. The function is then applied to all the rows in the window. The window "slides" through the query result set or partition from top-to-bottom.
The WINDOW BUFFER operation supports an analytic function.
Option: BUFFER PUSHED RANK
The WINDOW BUFFER PUSHED RANK operation supports an analytic function while executing the RANK function.
The WINDOW NOSORT operation retrieves data without sorting for an analytic function.
Option: NOSORT STOPKEY
The WINDOW NOSORT STOPKEY operation retrieves data without sorting for an analytic function. Query results are limited by conditions defined by the stopkey.
The WINDOW SORT operation sorts data for an analytic function.
Option: SORT PUSHED RANK
The WINDOW SORT PUSHED RANK operation sorts data before executing the RANK function for an analytic function.
Optimize SQL consists of SQL Rewrite sessions and Plan Control sessions. You can use SQL Rewrite sessions to optimize SQL statements by generating SQL statement or index alternatives. Use Plan Control sessions to generate execution plan alternatives for SQL statements without modifying the SQL text.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create a new session
Click the arrow beside and select New SQL Rewrite Session or New Plan Control Session.
Tip: Select Switch Default Session Type to Plan Control to change the default setting for new sessions. The default setting is to create a SQL Rewrite session.
To open a session
Select a SQL Rewrite or Plan Control session to open.
Tip: Click to import a session created in Tuning Lab 7.4 or earlier.