GENERAL INFORMATION SECTION ------------------------------------------------------------------------------- Tuning Task Name : SH_STA Tuning Task Owner : SYS Workload Type : SQL Tuning Set Scope : COMPREHENSIVE Time Limit(seconds) : 3600 Completion Status : COMPLETED Started at : 11/15/2017 18:33:06 Completed at : 11/15/2017 18:36:03 SQL Tuning Set (STS) Name : sh_workload SQL Tuning Set Owner : SYS Number of Statements in the STS : 59 ------------------------------------------------------------------------------- SUMMARY SECTION ------------------------------------------------------------------------------- Global SQL Tuning Result Statistics ------------------------------------------------------------------------------- Number of SQLs Analyzed : 59 Number of SQLs in the Report : 59 Number of SQLs with Findings : 59 Number of SQLs with SQL profiles recommended : 1 Number of SQLs with Index Findings : 1 ------------------------------------------------------------------------------- SQLs with Findings Ordered by Maximum (Profile/Index) Benefit, Object ID ------------------------------------------------------------------------------- object ID SQL ID statistics profile(benefit) index(benefit) restructure ---------- ------------- ---------- ---------------- -------------- ----------- 2 0bg8rg9srv8rm 59.75% 59.85% ------------------------------------------------------------------------------- Tables with New Potential Indices (ordered by schema, number of times, table) ------------------------------------------------------------------------------- Schema Name Table Name Index Name Nb Time --------------------------- --------------------------- -------------- -------- SH TIMES IDX$$_00A90001 1 ------------------------------------------------------------------------------- DETAILS SECTION ------------------------------------------------------------------------------- Statements with Results Ordered by Maximum (Profile/Index) Benefit, Object ID ------------------------------------------------------------------------------- Object ID : 2 Schema Name: SH SQL ID : 0bg8rg9srv8rm SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2012-3' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- FINDINGS SECTION (2 findings) ------------------------------------------------------------------------------- 1- SQL Profile Finding (see explain plans section below) -------------------------------------------------------- Se han encontrado 2 planes de ejecución potencialmente mejores para esta sentencia. Seleccione uno de los siguientes perfiles SQL para implantarlo. Recommendation (estimated benefit<=10%) --------------------------------------- - Puede aceptar el perfil SQL recomendado. execute dbms_sqltune.accept_sql_profile(task_name => 'SH_STA', object_id => 2, task_owner => 'SYS', replace => TRUE); Validation results ------------------ Se ha probado SQL profile ejecutando su plan y el plan original y midiendo sus respectivas estadísticas de ejecución. Puede que uno de los planes se haya ejecutado sólo parcialmente si el otro se ha ejecutado por completo en menos tiempo.r Original Plan With SQL Profile % Improved ------------- ---------------- ---------- Completion Status: COMPLETE COMPLETE Elapsed Time (s): 6.156003 .232187 96.22 % CPU Time (s): 4.890257 .265159 94.57 % User I/O Time (s): 1.626703 0 100 % Buffer Gets: 15965 15965 0 % Physical Read Requests: 1053 0 100 % Physical Write Requests: 0 0 Physical Read Bytes: 15032320 0 100 % Physical Write Bytes: 0 0 Rows Processed: 15 15 Fetches: 15 15 Executions: 1 1 Notes ----- 1. La media de las estadísticas de the original plan se ha realizado sobre 1 ejecuciones. 2. La media de las estadísticas de the SQL profile plan se ha realizado sobre 5 ejecuciones. Recommendation (estimated benefit: 59.75%) ------------------------------------------ - Puede aceptar el perfil de SQL recomendado para utilizar la ejecución paralela para esta sentencia. execute dbms_sqltune.accept_sql_profile(task_name => 'SH_STA', object_id => 2, task_owner => 'SYS', replace => TRUE, profile_type => DBMS_SQLTUNE.PX_PROFILE); La ejecución de esta consulta en paralelo con DOP 2 mejorará su tiempo de respuesta 59.71% con el plan de perfil SQL, pero la ejecución paralela tiene inconvenientes. Aumentará el consumo de recursos de la sentencia sobre un 19.42%, lo que puede reducir la productividad del sistema. Además, como estos recursos se utilizan en un tiempo mucho más breve, el tiempo de respuesta de sentencias simultáneas se podría ver afectada de forma negativa si el hardware no tiene la capacidad suficiente. The following data shows some sampled statistics for this SQL from the past week and projected weekly values when parallel execution is enabled. Past week sampled statistics for this SQL ----------------------------------------- Number of executions 0 Percent of total activity 0 Percent of samples with #Active Sessions > 2*CPU 0 Weekly DB time (in sec) 0 Projected statistics with Parallel Execution -------------------------------------------- Weekly DB time (in sec) 0 2- Index Finding (see explain plans section below) -------------------------------------------------- El plan de ejecución de esta sentencia se puede mejorar mediante la creación de uno o más índices. Recommendation (estimated benefit: 59.85%) ------------------------------------------ - Puede ejecutar el Asesor de Acceso para mejorar el diseńo del esquema físico o crear el índice recomendado. create index SH.IDX$$_00A90001 on SH.TIMES("CALENDAR_QUARTER_DESC","TIME_ID "); Rationale --------- La creación de índices recomendados mejora significativamente el plan de ejecución de esta sentencia. Sin embargo, puede ser preferible ejecutar el "Asesor de Acceso" mediante una carga de trabajo SQL representativa en contraposición a una única sentencia. Esto permitirá obtener recomendaciones de índice globales que tienen en cuenta la sobrecarga de mantenimiento de índice y el consumo de espacio adicional. ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original With Adjusted Cost ------------------------------ Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 50989 | 3883K| | 6002 (1)| 00:00:01 | |* 1 | VIEW | | 50989 | 3883K| | 6002 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 50989 | 2539K| 3224K| 6002 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 50989 | 2539K| 3224K| 6002 (1)| 00:00:01 | |* 4 | HASH JOIN | | 50989 | 2539K| 2168K| 4706 (1)| 00:00:01 | |* 5 | HASH JOIN | | 51561 | 1560K| | 3156 (1)| 00:00:01 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2012-3') 2- Using New Indices -------------------- Plan hash value: 705884735 ----------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib | ----------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 50989 | 3883K| | 2407 (1)| 00:00:05 | | | | | 1 | PX COORDINATOR | | | | | | | | | | | 2 | PX SEND QC (RANDOM) | :TQ10004 | 50989 | 3883K| | 2407 (1)| 00:00:05 | Q1,04 | P->S | QC (RAND) | |* 3 | VIEW | | 50989 | 3883K| | 2407 (1)| 00:00:05 | Q1,04 | PCWP | | |* 4 | WINDOW SORT PUSHED RANK | | 50989 | 2539K| 6440K| 2407 (1)| 00:00:05 | Q1,04 | PCWP | | | 5 | PX RECEIVE | | 50989 | 2539K| | 2407 (1)| 00:00:05 | Q1,04 | PCWP | | | 6 | PX SEND HASH | :TQ10003 | 50989 | 2539K| | 2407 (1)| 00:00:05 | Q1,03 | P->P | HASH | |* 7 | WINDOW CHILD PUSHED RANK | | 50989 | 2539K| | 2407 (1)| 00:00:05 | Q1,03 | PCWP | | | 8 | SORT GROUP BY | | 50989 | 2539K| 6440K| 2407 (1)| 00:00:05 | Q1,03 | PCWP | | | 9 | PX RECEIVE | | 50989 | 2539K| | 2404 (1)| 00:00:05 | Q1,03 | PCWP | | | 10 | PX SEND HASH | :TQ10002 | 50989 | 2539K| | 2404 (1)| 00:00:05 | Q1,02 | P->P | HASH | |* 11 | HASH JOIN | | 50989 | 2539K| | 2404 (1)| 00:00:05 | Q1,02 | PCWP | | | 12 | PX RECEIVE | | 51561 | 1560K| | 1739 (1)| 00:00:04 | Q1,02 | PCWP | | | 13 | PX SEND BROADCAST | :TQ10001 | 51561 | 1560K| | 1739 (1)| 00:00:04 | Q1,01 | P->P | BROADCAST | |* 14 | HASH JOIN | | 51561 | 1560K| | 1739 (1)| 00:00:04 | Q1,01 | PCWP | | | 15 | BUFFER SORT | | | | | | | Q1,01 | PCWC | | | 16 | PX RECEIVE | | 91 | 1365 | | 2 (0)| 00:00:01 | Q1,01 | PCWP | | | 17 | PX SEND BROADCAST| :TQ10000 | 91 | 1365 | | 2 (0)| 00:00:01 | | S->P | BROADCAST | |* 18 | INDEX RANGE SCAN| IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | | | | 19 | PX BLOCK ITERATOR | | 1472K| 22M| | 1735 (1)| 00:00:04 | Q1,01 | PCWC | | | 20 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 1735 (1)| 00:00:04 | Q1,01 | PCWP | | | 21 | PX BLOCK ITERATOR | | 162K| 3175K| | 664 (0)| 00:00:02 | Q1,02 | PCWC | | | 22 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 664 (0)| 00:00:02 | Q1,02 | PCWP | | ----------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 3 - filter("RANK_WITHIN_QUARTER"<16) 4 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 7 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 11 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 14 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 18 - access("TIMES"."CALENDAR_QUARTER_DESC"='2012-3') 3- Using Parallel Execution --------------------------- Plan hash value: 154555558 ------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib | ------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 50989 | 3883K| | 2416 (1)| 00:00:05 | | | | | 1 | PX COORDINATOR | | | | | | | | | | | 2 | PX SEND QC (RANDOM) | :TQ10004 | 50989 | 3883K| | 2416 (1)| 00:00:05 | Q1,04 | P->S | QC (RAND) | |* 3 | VIEW | | 50989 | 3883K| | 2416 (1)| 00:00:05 | Q1,04 | PCWP | | |* 4 | WINDOW SORT PUSHED RANK | | 50989 | 2539K| 6440K| 2416 (1)| 00:00:05 | Q1,04 | PCWP | | | 5 | PX RECEIVE | | 50989 | 2539K| | 2416 (1)| 00:00:05 | Q1,04 | PCWP | | | 6 | PX SEND HASH | :TQ10003 | 50989 | 2539K| | 2416 (1)| 00:00:05 | Q1,03 | P->P | HASH | |* 7 | WINDOW CHILD PUSHED RANK | | 50989 | 2539K| | 2416 (1)| 00:00:05 | Q1,03 | PCWP | | | 8 | SORT GROUP BY | | 50989 | 2539K| 6440K| 2416 (1)| 00:00:05 | Q1,03 | PCWP | | | 9 | PX RECEIVE | | 50989 | 2539K| | 2413 (1)| 00:00:05 | Q1,03 | PCWP | | | 10 | PX SEND HASH | :TQ10002 | 50989 | 2539K| | 2413 (1)| 00:00:05 | Q1,02 | P->P | HASH | |* 11 | HASH JOIN | | 50989 | 2539K| | 2413 (1)| 00:00:05 | Q1,02 | PCWP | | | 12 | PX RECEIVE | | 51561 | 1560K| | 1748 (1)| 00:00:04 | Q1,02 | PCWP | | | 13 | PX SEND BROADCAST | :TQ10001 | 51561 | 1560K| | 1748 (1)| 00:00:04 | Q1,01 | P->P | BROADCAST | |* 14 | HASH JOIN | | 51561 | 1560K| | 1748 (1)| 00:00:04 | Q1,01 | PCWP | | | 15 | PX RECEIVE | | 91 | 1365 | | 11 (0)| 00:00:01 | Q1,01 | PCWP | | | 16 | PX SEND BROADCAST | :TQ10000 | 91 | 1365 | | 11 (0)| 00:00:01 | Q1,00 | P->P | BROADCAST | | 17 | PX BLOCK ITERATOR | | 91 | 1365 | | 11 (0)| 00:00:01 | Q1,00 | PCWC | | |* 18 | TABLE ACCESS FULL| TIMES | 91 | 1365 | | 11 (0)| 00:00:01 | Q1,00 | PCWP | | | 19 | PX BLOCK ITERATOR | | 1472K| 22M| | 1735 (1)| 00:00:04 | Q1,01 | PCWC | | | 20 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 1735 (1)| 00:00:04 | Q1,01 | PCWP | | | 21 | PX BLOCK ITERATOR | | 162K| 3175K| | 664 (0)| 00:00:02 | Q1,02 | PCWC | | | 22 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 664 (0)| 00:00:02 | Q1,02 | PCWP | | ------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 3 - filter("RANK_WITHIN_QUARTER"<16) 4 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 7 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 11 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 14 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 18 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2012-3') 4- Using SQL Profile -------------------- Plan hash value: 3797694661 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 50989 | 3883K| | 5996 (1)| 00:01:12 | |* 1 | VIEW | | 50989 | 3883K| | 5996 (1)| 00:01:12 | |* 2 | WINDOW SORT PUSHED RANK| | 50989 | 2539K| 6440K| 5996 (1)| 00:01:12 | | 3 | SORT GROUP BY | | 50989 | 2539K| 6440K| 5996 (1)| 00:01:12 | |* 4 | HASH JOIN | | 50989 | 2539K| 2168K| 4698 (1)| 00:00:57 | |* 5 | HASH JOIN | | 51561 | 1560K| | 3148 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3125 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1196 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2012-3') ------------------------------------------------------------------------------- Object ID : 3 Schema Name: SH SQL ID : 5vbwrcz3vw3s0 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2013-3' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2013-3') ------------------------------------------------------------------------------- Object ID : 4 Schema Name: SH SQL ID : 9w0c53r5um1xy SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2011-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2011-4') ------------------------------------------------------------------------------- Object ID : 5 Schema Name: SH SQL ID : 6n5rbcc9c9tvs SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2012-2' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2012-2') ------------------------------------------------------------------------------- Object ID : 6 Schema Name: SH SQL ID : 9aft7htmzpd1d SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2004-2' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2004-2') ------------------------------------------------------------------------------- Object ID : 7 Schema Name: SH SQL ID : 9b723qjgkmy9z SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2009-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2009-4') ------------------------------------------------------------------------------- Object ID : 8 Schema Name: SH SQL ID : cmkygw8kypnpb SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2013-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2013-4') ------------------------------------------------------------------------------- Object ID : 9 Schema Name: SH SQL ID : 954q4b1vkp8m4 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2008-2' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2008-2') ------------------------------------------------------------------------------- Object ID : 10 Schema Name: SH SQL ID : 28da8t4nc8uk9 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2009-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2009-1') ------------------------------------------------------------------------------- Object ID : 11 Schema Name: SH SQL ID : 56nj9ptzakm56 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2011-2' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2011-2') ------------------------------------------------------------------------------- Object ID : 12 Schema Name: SH SQL ID : 8g3y654ptjzrz SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2010-2' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2010-2') ------------------------------------------------------------------------------- Object ID : 13 Schema Name: SH SQL ID : 3zdr12jv606xs SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2011-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2011-1') ------------------------------------------------------------------------------- Object ID : 14 Schema Name: SH SQL ID : 3fgwfcsa2k3bz SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2008-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2008-4') ------------------------------------------------------------------------------- Object ID : 15 Schema Name: SH SQL ID : 8wskn4vvvkd93 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2013-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2013-1') ------------------------------------------------------------------------------- Object ID : 16 Schema Name: SH SQL ID : gx7ymx5myrd2t SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2008-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2008-1') ------------------------------------------------------------------------------- Object ID : 17 Schema Name: SH SQL ID : 709uggnu40a9a SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2012-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2012-4') ------------------------------------------------------------------------------- Object ID : 18 Schema Name: SH SQL ID : 416hz7t3mx918 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2009-3' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2009-3') ------------------------------------------------------------------------------- Object ID : 19 Schema Name: SH SQL ID : 5hppq6bp5wmnm SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2006-3' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2006-3') ------------------------------------------------------------------------------- Object ID : 20 Schema Name: SH SQL ID : 1xmq1jkcnp2mf SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2006-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2006-4') ------------------------------------------------------------------------------- Object ID : 21 Schema Name: SH SQL ID : c6axjhw2bv23t SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2013-2' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2013-2') ------------------------------------------------------------------------------- Object ID : 22 Schema Name: SH SQL ID : 1qr4ps69f36jy SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2006-2' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2006-2') ------------------------------------------------------------------------------- Object ID : 23 Schema Name: SH SQL ID : au7x78c2uju0p SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2005-3' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2005-3') ------------------------------------------------------------------------------- Object ID : 24 Schema Name: SH SQL ID : a75y9uq84au4p SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2010-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2010-4') ------------------------------------------------------------------------------- Object ID : 25 Schema Name: SH SQL ID : aktx221b6sqc4 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '1997-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='1997-1') ------------------------------------------------------------------------------- Object ID : 26 Schema Name: SH SQL ID : dfdg44tjr89uf SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2010-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2010-1') ------------------------------------------------------------------------------- Object ID : 27 Schema Name: SH SQL ID : 9fsjrrksxp4gj SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2000-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2000-1') ------------------------------------------------------------------------------- Object ID : 28 Schema Name: SH SQL ID : 370m5yqjjcr8z SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '1997-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='1997-4') ------------------------------------------------------------------------------- Object ID : 29 Schema Name: SH SQL ID : a9nt3xdwup082 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2007-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2007-1') ------------------------------------------------------------------------------- Object ID : 30 Schema Name: SH SQL ID : 1p5p7drt7atxd SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2001-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2001-4') ------------------------------------------------------------------------------- Object ID : 31 Schema Name: SH SQL ID : 222q8cuf6ugt9 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2010-3' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2010-3') ------------------------------------------------------------------------------- Object ID : 32 Schema Name: SH SQL ID : 4kwqmbh8cs1gp SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '1998-3' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='1998-3') ------------------------------------------------------------------------------- Object ID : 33 Schema Name: SH SQL ID : 4wazxyxv5cpt0 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2005-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2005-1') ------------------------------------------------------------------------------- Object ID : 34 Schema Name: SH SQL ID : 1zm0sn3qcx0hu SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2009-2' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2009-2') ------------------------------------------------------------------------------- Object ID : 35 Schema Name: SH SQL ID : fwsw6473mw961 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2004-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2004-1') ------------------------------------------------------------------------------- Object ID : 36 Schema Name: SH SQL ID : gpxukn3ft9qgw SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2011-3' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2011-3') ------------------------------------------------------------------------------- Object ID : 37 Schema Name: SH SQL ID : 03ghr9b5m3x43 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2003-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2003-4') ------------------------------------------------------------------------------- Object ID : 38 Schema Name: SH SQL ID : 9tkfxkjugywqp SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2014-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2014-4') ------------------------------------------------------------------------------- Object ID : 39 Schema Name: SH SQL ID : fx2c47hcyfz9f SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2006-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2006-1') ------------------------------------------------------------------------------- Object ID : 40 Schema Name: SH SQL ID : 9h2u2z9y900yk SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '1999-3' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='1999-3') ------------------------------------------------------------------------------- Object ID : 41 Schema Name: SH SQL ID : gppx8hpcwsb5g SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2012-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2012-1') ------------------------------------------------------------------------------- Object ID : 42 Schema Name: SH SQL ID : fd5j4mmztdpmm SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2003-3' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2003-3') ------------------------------------------------------------------------------- Object ID : 43 Schema Name: SH SQL ID : 08kysb4nyt58n SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '1995-4' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='1995-4') ------------------------------------------------------------------------------- Object ID : 44 Schema Name: SH SQL ID : 8hytq9ybsh5xu SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2000-2' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2000-2') ------------------------------------------------------------------------------- Object ID : 45 Schema Name: SH SQL ID : 83wufms0kwjb0 SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '1995-3' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='1995-3') ------------------------------------------------------------------------------- Object ID : 46 Schema Name: SH SQL ID : 7f6kr3z5p8qxa SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2002-2' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2002-2') ------------------------------------------------------------------------------- Object ID : 47 Schema Name: SH SQL ID : 8k0bufga1dutt SQL Text : SELECT * FROM (SELECT times.calendar_quarter_desc, customers.cust_first_name, customers.cust_last_name, customers.cust_id, SUM(sales.amount_sold), rank() over(PARTITION BY times.calendar_quarter_desc ORDER BY SUM(amount_sold) DESC) AS rank_within_quarter FROM sales, customers, times WHERE sales.cust_id = customers.cust_id AND times.calendar_quarter_desc = '2002-1' AND times.time_id = sales.time_id GROUP BY customers.cust_id, customers.cust_first_name, customers.cust_last_name, customers.cust_id, times.calendar_quarter_desc) WHERE rank_within_quarter < 16 ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - El optimizador no ha podido fusionar la vista en el identificador de línea 1 del plan de ejecución. El optimizador no puede fusionar ninguna vista que contenga funciones de ventana. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 3551373025 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 1 | VIEW | | 19225 | 1464K| | 4849 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19225 | 957K| 2440K| 4849 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19225 | 957K| | 4354 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19440 | 588K| | 3157 (1)| 00:00:38 | |* 6 | TABLE ACCESS FULL | TIMES | 91 | 1365 | | 19 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:38 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:15 | ---------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - filter("TIMES"."CALENDAR_QUARTER_DESC"='2002-1') ------------------------------------------------------------------------------- Object ID : 48 Schema Name: SH SQL ID : fy8v6kg0spv9f SQL Text : BEGIN dbms_application_info.set_module('SalesByWeekCountry', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 49 Schema Name: SH SQL ID : c860hqput21a4 SQL Text : BEGIN dbms_application_info.set_module('TopSalesWithinQuarter', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 50 Schema Name: SH SQL ID : 23bdv7p1xf88s SQL Text : BEGIN dbms_application_info.set_module('SalesMovingAverage', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 51 Schema Name: SH SQL ID : 96uvdds9xf676 SQL Text : BEGIN dbms_application_info.set_module('SalesCubeByWeek', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 52 Schema Name: SH SQL ID : dxqdy7uch79qn SQL Text : BEGIN dbms_application_info.set_module('SalesByQuarterCountry', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 53 Schema Name: SH SQL ID : 772ank4p8pcha SQL Text : BEGIN dbms_application_info.set_module('SalesRollupByWeek', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 54 Schema Name: SH SQL ID : 7p3m5a493ys3v SQL Text : BEGIN dbms_application_info.set_module('SalesRollupByMonth', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 55 Schema Name: SH SQL ID : ahagwf5568kh6 SQL Text : BEGIN dbms_application_info.set_module('SalesCubeByMonth', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 56 Schema Name: SH SQL ID : bph8vd0ct58yz SQL Text : BEGIN dbms_application_info.set_module('TopSalesWithinWeek', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 57 Schema Name: SH SQL ID : ccn2d3x50s9sq SQL Text : BEGIN dbms_application_info.set_module('ProductSalesRollupCube', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 58 Schema Name: SH SQL ID : 7dkpwxm9qu436 SQL Text : BEGIN dbms_application_info.set_module('ProductMonthlySalesRollup Cube', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 59 Schema Name: SH SQL ID : ad5f7gub3vkmb SQL Text : BEGIN dbms_application_info.set_module('WeekToWeekComparison', null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. ------------------------------------------------------------------------------- Object ID : 60 Schema Name: SH SQL ID : djqf09v8rzk0f SQL Text : BEGIN dbms_application_info.set_module('PeriodToPeriodComparison' , null); END; ------------------------------------------------------------------------------- ADDITIONAL INFORMATION SECTION ------------------------------------------------------------------------------- - Tipo de sentencia SQL no soportado. -------------------------------------------------------------------------------