Chat now with support
Chat with Support

Spotlight on Oracle 10.7 - Release Notes

Aggregation Operations

The following table shows some of the aggregation operations you may encounter while using the Explain SQL window.

Operation Option Description

COUNT

  

Count the rows in the result set in order to satisfy the COUNT() function.

COUNT

STOPKEY

Count the number of rows returned by a result set, and stop processing when a certain number of rows are reached. This is usually the result of a WHERE clause which specifies a maximum ROWNUM (for instance WHERE ROWNUM <= 10).

SORT

AGGREGATE

This occurs when a group function is used on data that is already grouped. For instance, select MAX(AVG(SALARY)) from EMPLOYEES GROUP by MANAGER_ID.

SORT

JOIN

Sort the rows in preparation for a merge join.

SORT

UNIQUE

A sort to eliminate duplicate rows. Typically occurs as a result of using the distinct clause.

PARTITION

SINGLE

Denotes that operations were performed on a single partition.

PARTITION

CONCATENATED

Denotes that operations were performed on multiple partitions.

LOAD

AS SELECT

Denotes an insert append operation.

SORT

GROUP BY

A sort of a result set in order to group them for the GROUP BY CLAUSE.

 

Related Topics

Tools | Explain Plan

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating