EXPLAINED SQL STATEMENT: |
------------------------ |
SELECT /**/ DISTINCT CUSTOMER_NAME FROM SALES ORDER BY LAST_SALE_DATE |
desc FETCH FIRST 6 ROWS ONLY |
|
Plan hash value: 704191591 |
|
------------------------------------------ |
| Id | Operation | Name | |
------------------------------------------ |
| 0 | SELECT STATEMENT | | |
| 1 | VIEW | | |
| 2 | WINDOW SORT PUSHED RANK| | |
| 3 | VIEW | | |
| 4 | HASH UNIQUE | | |
| 5 | TABLE ACCESS FULL | SALES | |
------------------------------------------ |
|
Column Projection Information (identified by operation id): |
----------------------------------------------------------- |
|
1 - (rowset=256) "from$_subquery$_003"."CUSTOMER_NAME"[VARCHAR2,16], |
"from$_subquery$_003"."rowlimit_$$_rownumber"[NUMBER,22] |
2 - (#keys=1; rowset=256) "from$_subquery$_002"."rowlimit_$_0"[DATE,7 |
], "from$_subquery$_002"."CUSTOMER_NAME"[VARCHAR2,16], ROW_NUMBER() |
OVER ( ORDER BY INTERNAL_FUNCTION("from$_subquery$_002"."rowlimit_$_0") |
DESC )[22] |
3 - (rowset=256) "from$_subquery$_002"."CUSTOMER_NAME"[VARCHAR2,16], |
"from$_subquery$_002"."rowlimit_$_0"[DATE,7] |
4 - (#keys=2; rowset=256) "CUSTOMER_NAME"[VARCHAR2,16], |
"LAST_SALE_DATE"[DATE,7] |
5 - (rowset=256) "CUSTOMER_NAME"[VARCHAR2,16], |
"LAST_SALE_DATE"[DATE,7] |
|