Window

The window is a temporary object that holds intermediate results needed to determine the result for On-Line Analytical Processing (OLAP) functions. The number of rows in the window may change as the data flows through it.

The window is an internal data structure and can only be created by the database manager.

Visual explain icon:

Window icon