GENERAL INFORMATION SECTION ------------------------------------------------------------------------------- Tuning Task Name : SH_SPA Tuning Task Owner : SYS Workload Type : SQL Tuning Set Execution Count : 2 Current Execution : sh_after_change Execution Type : TEST EXECUTE Scope : COMPREHENSIVE Completion Status : COMPLETED Started at : 11/16/2017 09:29:12 Completed at : 11/16/2017 09:30:04 SQL Tuning Set (STS) Name : sh_workload SQL Tuning Set Owner : SYS Number of Statements in the STS : 59 Number of SQLs Analyzed : 59 Number of SQLs in the Report : 59 Number of SQLs with Findings : 13 ------------------------------------------------------------------------------- SUMMARY SECTION ------------------------------------------------------------------------------- SQL Statements Ordered by Elapsed Time ------------------------------------------------------------------------------- Parse Elapsed CPU Buffer Optimizer object ID SQL ID Time (s) Time (s) Time (s) Gets Cost ---------- ------------- -------- -------- -------- -------- --------- 74 3fgwfcsa2k3bz .000538 .286008 .276208 15906 4834 72 28da8t4nc8uk9 .000725 .259357 .255761 15906 4824 83 709uggnu40a9a .00052 .258583 .258294 15906 4834 81 5vbwrcz3vw3s0 .000514 .246455 .246212 15906 4834 111 cmkygw8kypnpb .000569 .243968 .244213 15907 4834 65 0bg8rg9srv8rm .00052 .23756 .237214 15906 4834 100 9w0c53r5um1xy .000587 .223233 .223716 15906 4834 82 6n5rbcc9c9tvs .000708 .218336 .218466 15907 4832 93 954q4b1vkp8m4 .000544 .215175 .214967 15906 4832 120 gpxukn3ft9qgw .000474 .208415 .208468 15907 4834 108 c6axjhw2bv23t .000488 .208141 .208718 15906 4832 96 9b723qjgkmy9z .000528 .205658 .205718 15906 4834 101 a75y9uq84au4p .000554 .204695 .204469 15907 4834 119 gppx8hpcwsb5g .000504 .202939 .202219 15906 4832 79 56nj9ptzakm56 .00088 .199834 .200169 15906 4832 92 8wskn4vvvkd93 .000573 .199487 .199569 15907 4824 70 222q8cuf6ugt9 .000475 .195544 .19577 15906 4834 75 3zdr12jv606xs .000455 .192963 .19237 15906 4824 89 8g3y654ptjzrz .000639 .187166 .187371 15906 4832 76 416hz7t3mx918 .000548 .186773 .186971 15906 4834 112 dfdg44tjr89uf .000519 .184686 .184972 15907 4824 69 1zm0sn3qcx0hu .000618 .180303 .180572 15907 4832 68 1xmq1jkcnp2mf .000494 .172516 .172373 15906 4834 80 5hppq6bp5wmnm .000538 .165611 .165974 15906 4834 121 gx7ymx5myrd2t .000772 .162516 .162808 15906 4832 102 a9nt3xdwup082 .000551 .15958 .159809 15907 4824 66 1p5p7drt7atxd .000608 .157684 .157976 15907 4834 67 1qr4ps69f36jy .000465 .155863 .155976 15907 4832 117 fx2c47hcyfz9f .000556 .155689 .155643 15906 4824 77 4kwqmbh8cs1gp .000688 .155369 .155643 15906 4834 78 4wazxyxv5cpt0 .000588 .153237 .15331 15906 4824 98 9h2u2z9y900yk .000515 .152415 .152476 15907 4834 63 03ghr9b5m3x43 .000523 .152393 .152643 15906 4834 115 fd5j4mmztdpmm .000562 .151871 .151976 15906 4834 90 8hytq9ybsh5xu .000611 .149083 .14931 15907 4832 95 9aft7htmzpd1d .000506 .149057 .14931 15906 4832 116 fwsw6473mw961 .000532 .148999 .148977 15907 4832 73 370m5yqjjcr8z .000822 .147347 .147477 15906 4834 86 7f6kr3z5p8qxa .000515 .144216 .144311 15906 4832 97 9fsjrrksxp4gj .000468 .143245 .143145 15906 4832 106 au7x78c2uju0p .000565 .14286 .142835 15907 4834 91 8k0bufga1dutt .000548 .141978 .142121 15906 4824 64 08kysb4nyt58n .00055 .138697 .138978 15907 4834 105 aktx221b6sqc4 .000741 .13854 .138264 15906 4824 88 83wufms0kwjb0 .000773 .135088 .135122 15906 4834 99 9tkfxkjugywqp .000885 .117203 .117107 11520 4834 ------------------------------------------------------------------------------- DETAILS SECTION ------------------------------------------------------------------------------- SQL Statements Ordered by Elapsed Time ------------------------------------------------------------------------------- Object ID : 74 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000538 Elapsed Time (s): .286008 CPU Time (s): .276208 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2008-4') ------------------------------------------------------------------------------- Object ID : 72 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000725 Elapsed Time (s): .259357 CPU Time (s): .255761 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4824 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 5 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 1 | VIEW | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | |* 4 | HASH JOIN | | 18948 | 943K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19161 | 580K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2009-1') ------------------------------------------------------------------------------- Object ID : 83 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .00052 Elapsed Time (s): .258583 CPU Time (s): .258294 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 3 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2012-4') ------------------------------------------------------------------------------- Object ID : 81 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000514 Elapsed Time (s): .246455 CPU Time (s): .246212 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2013-3') ------------------------------------------------------------------------------- Object ID : 111 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000569 Elapsed Time (s): .243968 CPU Time (s): .244213 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2013-4') ------------------------------------------------------------------------------- Object ID : 65 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .00052 Elapsed Time (s): .23756 CPU Time (s): .237214 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2012-3') ------------------------------------------------------------------------------- Object ID : 100 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000587 Elapsed Time (s): .223233 CPU Time (s): .223716 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2011-4') ------------------------------------------------------------------------------- Object ID : 82 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000708 Elapsed Time (s): .218336 CPU Time (s): .218466 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2012-2') ------------------------------------------------------------------------------- Object ID : 93 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000544 Elapsed Time (s): .215175 CPU Time (s): .214967 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2008-2') ------------------------------------------------------------------------------- Object ID : 120 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000474 Elapsed Time (s): .208415 CPU Time (s): .208468 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2011-3') ------------------------------------------------------------------------------- Object ID : 108 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000488 Elapsed Time (s): .208141 CPU Time (s): .208718 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2013-2') ------------------------------------------------------------------------------- Object ID : 96 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000528 Elapsed Time (s): .205658 CPU Time (s): .205718 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2009-4') ------------------------------------------------------------------------------- Object ID : 101 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000554 Elapsed Time (s): .204695 CPU Time (s): .204469 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2010-4') ------------------------------------------------------------------------------- Object ID : 119 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000504 Elapsed Time (s): .202939 CPU Time (s): .202219 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 4 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2012-1') ------------------------------------------------------------------------------- Object ID : 79 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .00088 Elapsed Time (s): .199834 CPU Time (s): .200169 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 5 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2011-2') ------------------------------------------------------------------------------- Object ID : 92 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000573 Elapsed Time (s): .199487 CPU Time (s): .199569 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4824 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 5 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 1 | VIEW | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | |* 4 | HASH JOIN | | 18948 | 943K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19161 | 580K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2013-1') ------------------------------------------------------------------------------- Object ID : 70 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000475 Elapsed Time (s): .195544 CPU Time (s): .19577 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 5 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2010-3') ------------------------------------------------------------------------------- Object ID : 75 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000455 Elapsed Time (s): .192963 CPU Time (s): .19237 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4824 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 5 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 1 | VIEW | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | |* 4 | HASH JOIN | | 18948 | 943K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19161 | 580K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2011-1') ------------------------------------------------------------------------------- Object ID : 89 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000639 Elapsed Time (s): .187166 CPU Time (s): .187371 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 5 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2010-2') ------------------------------------------------------------------------------- Object ID : 76 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000548 Elapsed Time (s): .186773 CPU Time (s): .186971 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 5 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2009-3') ------------------------------------------------------------------------------- Object ID : 112 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000519 Elapsed Time (s): .184686 CPU Time (s): .184972 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4824 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 5 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 1 | VIEW | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | |* 4 | HASH JOIN | | 18948 | 943K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19161 | 580K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2010-1') ------------------------------------------------------------------------------- Object ID : 69 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000618 Elapsed Time (s): .180303 CPU Time (s): .180572 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 17 Fetches: 17 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 5 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2009-2') ------------------------------------------------------------------------------- Object ID : 68 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000494 Elapsed Time (s): .172516 CPU Time (s): .172373 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 5 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2006-4') ------------------------------------------------------------------------------- Object ID : 80 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000538 Elapsed Time (s): .165611 CPU Time (s): .165974 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2006-3') ------------------------------------------------------------------------------- Object ID : 121 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000772 Elapsed Time (s): .162516 CPU Time (s): .162808 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2008-1') ------------------------------------------------------------------------------- Object ID : 102 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000551 Elapsed Time (s): .15958 CPU Time (s): .159809 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4824 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 1 | VIEW | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | |* 4 | HASH JOIN | | 18948 | 943K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19161 | 580K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2007-1') ------------------------------------------------------------------------------- Object ID : 66 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000608 Elapsed Time (s): .157684 CPU Time (s): .157976 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2001-4') ------------------------------------------------------------------------------- Object ID : 67 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000465 Elapsed Time (s): .155863 CPU Time (s): .155976 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2006-2') ------------------------------------------------------------------------------- Object ID : 117 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000556 Elapsed Time (s): .155689 CPU Time (s): .155643 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4824 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 1 | VIEW | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | |* 4 | HASH JOIN | | 18948 | 943K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19161 | 580K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2006-1') ------------------------------------------------------------------------------- Object ID : 77 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000688 Elapsed Time (s): .155369 CPU Time (s): .155643 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='1998-3') ------------------------------------------------------------------------------- Object ID : 78 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000588 Elapsed Time (s): .153237 CPU Time (s): .15331 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4824 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 1 | VIEW | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | |* 4 | HASH JOIN | | 18948 | 943K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19161 | 580K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2005-1') ------------------------------------------------------------------------------- Object ID : 98 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000515 Elapsed Time (s): .152415 CPU Time (s): .152476 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='1999-3') ------------------------------------------------------------------------------- Object ID : 63 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000523 Elapsed Time (s): .152393 CPU Time (s): .152643 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2003-4') ------------------------------------------------------------------------------- Object ID : 115 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000562 Elapsed Time (s): .151871 CPU Time (s): .151976 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2003-3') ------------------------------------------------------------------------------- Object ID : 90 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000611 Elapsed Time (s): .149083 CPU Time (s): .14931 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2000-2') ------------------------------------------------------------------------------- Object ID : 95 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000506 Elapsed Time (s): .149057 CPU Time (s): .14931 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2004-2') ------------------------------------------------------------------------------- Object ID : 116 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000532 Elapsed Time (s): .148999 CPU Time (s): .148977 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 17 Fetches: 17 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2004-1') ------------------------------------------------------------------------------- Object ID : 73 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000822 Elapsed Time (s): .147347 CPU Time (s): .147477 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 17 Fetches: 17 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='1997-4') ------------------------------------------------------------------------------- Object ID : 86 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000515 Elapsed Time (s): .144216 CPU Time (s): .144311 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2002-2') ------------------------------------------------------------------------------- Object ID : 97 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000468 Elapsed Time (s): .143245 CPU Time (s): .143145 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4832 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 6 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 1 | VIEW | | 19159 | 1459K| | 4832 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 19159 | 954K| 2424K| 4832 (1)| 00:00:58 | |* 4 | HASH JOIN | | 19159 | 954K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19374 | 586K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2000-1') ------------------------------------------------------------------------------- Object ID : 106 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000565 Elapsed Time (s): .14286 CPU Time (s): .142835 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 7 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2005-3') ------------------------------------------------------------------------------- Object ID : 91 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000548 Elapsed Time (s): .141978 CPU Time (s): .142121 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4824 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 7 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 1 | VIEW | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | |* 4 | HASH JOIN | | 18948 | 943K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19161 | 580K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2002-1') ------------------------------------------------------------------------------- Object ID : 64 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .00055 Elapsed Time (s): .138697 CPU Time (s): .138978 User I/O Time (s): 0 Buffer Gets: 15907 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 7 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='1995-4') ------------------------------------------------------------------------------- Object ID : 105 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000741 Elapsed Time (s): .13854 CPU Time (s): .138264 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4824 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 7 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 1 | VIEW | | 18948 | 1443K| | 4824 (1)| 00:00:58 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | | 3 | HASH GROUP BY | | 18948 | 943K| 2408K| 4824 (1)| 00:00:58 | |* 4 | HASH JOIN | | 18948 | 943K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19161 | 580K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='1997-1') ------------------------------------------------------------------------------- Object ID : 88 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000773 Elapsed Time (s): .135088 CPU Time (s): .135122 User I/O Time (s): 0 Buffer Gets: 15906 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 7 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19370 | 1475K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19370 | 964K| 2456K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19370 | 964K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19587 | 592K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='1995-3') ------------------------------------------------------------------------------- Object ID : 99 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 ------------------------------------------------------------------------------- Execution Statistics ------------------------------------------------------------------------------- Parse Time (s): .000885 Elapsed Time (s): .117203 CPU Time (s): .117107 User I/O Time (s): 0 Buffer Gets: 11520 Disk Reads: 0 Direct Writes: 0 I/O Interconnect Bytes: 0 Rows Processed: 0 Fetches: 0 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4834 Notes ----- 1. La sentencia se ha ejecutado en primer lugar para calentar la caché de buffers. 2. La media de las estadísticas mostradas se ha realizado sobre las siguientes 8 ejecuciones. ------------------------------------------------------------------------------- EXPLAIN PLANS SECTION ------------------------------------------------------------------------------- 1- Original ----------- Plan hash value: 4028546188 --------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19264 | 1467K| | 4834 (1)| 00:00:59 | |* 1 | VIEW | | 19264 | 1467K| | 4834 (1)| 00:00:59 | |* 2 | WINDOW SORT PUSHED RANK| | 19264 | 959K| 2440K| 4834 (1)| 00:00:59 | | 3 | HASH GROUP BY | | 19264 | 959K| 2440K| 4834 (1)| 00:00:59 | |* 4 | HASH JOIN | | 19264 | 959K| | 4337 (1)| 00:00:53 | |* 5 | HASH JOIN | | 19480 | 589K| | 3140 (1)| 00:00:38 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (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 - access("TIMES"."CALENDAR_QUARTER_DESC"='2014-4') ------------------------------------------------------------------------------- Object ID : 71 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 : 84 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 : 85 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 : 87 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 : 94 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 : 103 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 : 104 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 : 107 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 : 109 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 : 110 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 : 113 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. ------------------------------------------------------------------------------- Object ID : 114 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 : 118 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. -------------------------------------------------------------------------------