WINDOW (BUFFER)

Description

Analytic function

Versions

This operation was introduced in Oracle 8.1.6

This operation is implemented in the following versions

Example

Example 1

This example was developed using Oracle 9.2.0.1 on Windows 2000

This example requires the following table definition

    CREATE TABLE t1 (c1 NUMBER,c2 NUMBER);

The table does not need to be analysed

The statement

    SELECT VAR_POP (SUM (c1)) OVER (ORDER BY c2)
    FROM t1
    GROUP BY c2;

generates the following execution plan

0     SELECT STATEMENT Optimizer=CHOOSE
1   0   WINDOW (BUFFER)
2   1     SORT (GROUP BY)
3   2       TABLE ACCESS (FULL) OF 'T1'

Example 2

This example was developed using Oracle 9.2.0.1 on Windows 2000

This example requires the following table definition

    CREATE TABLE t1 (c1 NUMBER,c2 NUMBER);

The table does not need to be analysed

The statement

    SELECT VAR_SAMP (SUM (c1)) OVER (ORDER BY c2)
    FROM t1
    GROUP BY c2;

generates the following execution plan

0     SELECT STATEMENT Optimizer=CHOOSE
1   0   WINDOW (BUFFER)
2   1     SORT (GROUP BY)
3   2       TABLE ACCESS (FULL) OF 'T1'

Example 3

This example was developed using Oracle 9.2.0.1 on Windows 2000

This example requires the following table definition

    CREATE TABLE t1 (c1 NUMBER,c2 NUMBER);

The table does not need to be analysed

The statement

    SELECT c1,RATIO_TO_REPORT (c2) OVER ()
    FROM t1;

generates the following execution plan

0     SELECT STATEMENT Optimizer=CHOOSE
1   0   WINDOW (BUFFER)
2   1     TABLE ACCESS (FULL) OF 'T1'