GENERAL INFORMATION SECTION ------------------------------------------------------------------------------- Tuning Task Name : SH_SPA Tuning Task Owner : SYS Workload Type : SQL Tuning Set Execution Count : 5 Current Execution : sh_change_optimizer_12.1.0.1 Execution Type : TEST EXECUTE Scope : COMPREHENSIVE Completion Status : COMPLETED Started at : 11/16/2017 10:01:26 Completed at : 11/16/2017 10:02:19 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 ---------- ------------- -------- -------- -------- -------- --------- 261 709uggnu40a9a .003709 .270137 .286956 15906 4831 260 6n5rbcc9c9tvs .002082 .264639 .282623 15907 4829 274 9b723qjgkmy9z .001141 .257487 .266626 15906 4831 289 cmkygw8kypnpb .001358 .247736 .252711 15907 4831 259 5vbwrcz3vw3s0 .001252 .240068 .25721 15906 4831 243 0bg8rg9srv8rm .001143 .237607 .350196 15906 4831 278 9w0c53r5um1xy .001664 .234134 .240713 15906 4831 298 gpxukn3ft9qgw .001218 .225759 .229215 15907 4831 286 c6axjhw2bv23t .001222 .223152 .228215 15906 4829 279 a75y9uq84au4p .001297 .213663 .219216 15907 4831 257 56nj9ptzakm56 .001276 .203953 .221716 15906 4829 297 gppx8hpcwsb5g .001236 .202605 .206218 15906 4829 248 222q8cuf6ugt9 .001607 .199519 .239713 15906 4831 252 3fgwfcsa2k3bz .001312 .195457 .223766 15906 4831 270 8wskn4vvvkd93 .001302 .19541 .203769 15907 4821 254 416hz7t3mx918 .001511 .192267 .214567 15906 4831 290 dfdg44tjr89uf .001209 .190789 .19417 15907 4821 271 954q4b1vkp8m4 .001201 .189787 .19677 15906 4829 246 1xmq1jkcnp2mf .001276 .189733 .242163 15906 4831 247 1zm0sn3qcx0hu .001564 .187795 .232764 15907 4829 267 8g3y654ptjzrz .001471 .18568 .19457 15906 4829 253 3zdr12jv606xs .001288 .184517 .208168 15906 4821 250 28da8t4nc8uk9 .001914 .183273 .216567 15906 4821 299 gx7ymx5myrd2t .001286 .169956 .172373 15906 4829 244 1p5p7drt7atxd .001368 .169715 .234764 15907 4831 273 9aft7htmzpd1d .001875 .163365 .16964 15906 4829 241 03ghr9b5m3x43 .001699 .162999 .28429 15906 4831 245 1qr4ps69f36jy .001192 .161087 .214134 15907 4829 280 a9nt3xdwup082 .001438 .160222 .164641 15907 4821 258 5hppq6bp5wmnm .001245 .159708 .172307 15906 4831 295 fx2c47hcyfz9f .001266 .157286 .159809 15906 4821 284 au7x78c2uju0p .001553 .152711 .156143 15907 4831 256 4wazxyxv5cpt0 .001259 .151859 .166308 15906 4821 293 fd5j4mmztdpmm .00121 .150531 .15331 15906 4831 294 fwsw6473mw961 .001316 .149054 .15181 15907 4829 264 7f6kr3z5p8qxa .001353 .148892 .157809 15906 4829 283 aktx221b6sqc4 .001291 .148217 .15181 15906 4821 266 83wufms0kwjb0 .001208 .146791 .154643 15906 4831 269 8k0bufga1dutt .001393 .14631 .15281 15906 4821 268 8hytq9ybsh5xu .001584 .145742 .152476 15907 4829 255 4kwqmbh8cs1gp .001618 .145142 .160309 15906 4831 251 370m5yqjjcr8z .00181 .144521 .167807 15906 4831 276 9h2u2z9y900yk .001287 .144492 .148977 15907 4831 275 9fsjrrksxp4gj .002005 .141465 .146144 15906 4829 242 08kysb4nyt58n .00112 .139311 .222966 15907 4831 277 9tkfxkjugywqp .001065 .115812 .119356 11520 4831 ------------------------------------------------------------------------------- DETAILS SECTION ------------------------------------------------------------------------------- SQL Statements Ordered by Elapsed Time ------------------------------------------------------------------------------- Object ID : 261 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): .003709 Elapsed Time (s): .270137 CPU Time (s): .286956 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2012-4') ------------------------------------------------------------------------------- Object ID : 260 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): .002082 Elapsed Time (s): .264639 CPU Time (s): .282623 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: 4829 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 | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2012-2') ------------------------------------------------------------------------------- Object ID : 274 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): .001141 Elapsed Time (s): .257487 CPU Time (s): .266626 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2009-4') ------------------------------------------------------------------------------- Object ID : 289 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): .001358 Elapsed Time (s): .247736 CPU Time (s): .252711 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2013-4') ------------------------------------------------------------------------------- Object ID : 259 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): .001252 Elapsed Time (s): .240068 CPU Time (s): .25721 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2013-3') ------------------------------------------------------------------------------- Object ID : 243 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): .001143 Elapsed Time (s): .237607 CPU Time (s): .350196 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2012-3') ------------------------------------------------------------------------------- Object ID : 278 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): .001664 Elapsed Time (s): .234134 CPU Time (s): .240713 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2011-4') ------------------------------------------------------------------------------- Object ID : 298 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): .001218 Elapsed Time (s): .225759 CPU Time (s): .229215 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2011-3') ------------------------------------------------------------------------------- Object ID : 286 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): .001222 Elapsed Time (s): .223152 CPU Time (s): .228215 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: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2013-2') ------------------------------------------------------------------------------- Object ID : 279 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): .001297 Elapsed Time (s): .213663 CPU Time (s): .219216 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2010-4') ------------------------------------------------------------------------------- Object ID : 257 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): .001276 Elapsed Time (s): .203953 CPU Time (s): .221716 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: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2011-2') ------------------------------------------------------------------------------- Object ID : 297 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): .001236 Elapsed Time (s): .202605 CPU Time (s): .206218 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: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2012-1') ------------------------------------------------------------------------------- Object ID : 248 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): .001607 Elapsed Time (s): .199519 CPU Time (s): .239713 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2010-3') ------------------------------------------------------------------------------- Object ID : 252 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): .001312 Elapsed Time (s): .195457 CPU Time (s): .223766 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2008-4') ------------------------------------------------------------------------------- Object ID : 270 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): .001302 Elapsed Time (s): .19541 CPU Time (s): .203769 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: 4821 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| | 4821 (1)| 00:00:01 | |* 1 | VIEW | | 18948 | 1443K| | 4821 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | |* 4 | HASH JOIN | | 18948 | 943K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19161 | 580K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2013-1') ------------------------------------------------------------------------------- Object ID : 254 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): .001511 Elapsed Time (s): .192267 CPU Time (s): .214567 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2009-3') ------------------------------------------------------------------------------- Object ID : 290 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): .001209 Elapsed Time (s): .190789 CPU Time (s): .19417 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: 4821 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| | 4821 (1)| 00:00:01 | |* 1 | VIEW | | 18948 | 1443K| | 4821 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | |* 4 | HASH JOIN | | 18948 | 943K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19161 | 580K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2010-1') ------------------------------------------------------------------------------- Object ID : 271 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): .001201 Elapsed Time (s): .189787 CPU Time (s): .19677 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: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2008-2') ------------------------------------------------------------------------------- Object ID : 246 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): .001276 Elapsed Time (s): .189733 CPU Time (s): .242163 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2006-4') ------------------------------------------------------------------------------- Object ID : 247 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): .001564 Elapsed Time (s): .187795 CPU Time (s): .232764 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: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2009-2') ------------------------------------------------------------------------------- Object ID : 267 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): .001471 Elapsed Time (s): .18568 CPU Time (s): .19457 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: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2010-2') ------------------------------------------------------------------------------- Object ID : 253 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): .001288 Elapsed Time (s): .184517 CPU Time (s): .208168 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: 4821 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| | 4821 (1)| 00:00:01 | |* 1 | VIEW | | 18948 | 1443K| | 4821 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | |* 4 | HASH JOIN | | 18948 | 943K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19161 | 580K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2011-1') ------------------------------------------------------------------------------- Object ID : 250 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): .001914 Elapsed Time (s): .183273 CPU Time (s): .216567 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: 4821 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| | 4821 (1)| 00:00:01 | |* 1 | VIEW | | 18948 | 1443K| | 4821 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | |* 4 | HASH JOIN | | 18948 | 943K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19161 | 580K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2009-1') ------------------------------------------------------------------------------- Object ID : 299 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): .001286 Elapsed Time (s): .169956 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: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2008-1') ------------------------------------------------------------------------------- Object ID : 244 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): .001368 Elapsed Time (s): .169715 CPU Time (s): .234764 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2001-4') ------------------------------------------------------------------------------- Object ID : 273 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): .001875 Elapsed Time (s): .163365 CPU Time (s): .16964 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: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2004-2') ------------------------------------------------------------------------------- Object ID : 241 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): .001699 Elapsed Time (s): .162999 CPU Time (s): .28429 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2003-4') ------------------------------------------------------------------------------- Object ID : 245 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): .001192 Elapsed Time (s): .161087 CPU Time (s): .214134 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: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2006-2') ------------------------------------------------------------------------------- Object ID : 280 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): .001438 Elapsed Time (s): .160222 CPU Time (s): .164641 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: 4821 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| | 4821 (1)| 00:00:01 | |* 1 | VIEW | | 18948 | 1443K| | 4821 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | |* 4 | HASH JOIN | | 18948 | 943K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19161 | 580K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2007-1') ------------------------------------------------------------------------------- Object ID : 258 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): .001245 Elapsed Time (s): .159708 CPU Time (s): .172307 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2006-3') ------------------------------------------------------------------------------- Object ID : 295 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): .001266 Elapsed Time (s): .157286 CPU Time (s): .159809 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: 4821 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| | 4821 (1)| 00:00:01 | |* 1 | VIEW | | 18948 | 1443K| | 4821 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | |* 4 | HASH JOIN | | 18948 | 943K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19161 | 580K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2006-1') ------------------------------------------------------------------------------- Object ID : 284 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): .001553 Elapsed Time (s): .152711 CPU Time (s): .156143 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2005-3') ------------------------------------------------------------------------------- Object ID : 256 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): .001259 Elapsed Time (s): .151859 CPU Time (s): .166308 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: 4821 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| | 4821 (1)| 00:00:01 | |* 1 | VIEW | | 18948 | 1443K| | 4821 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | |* 4 | HASH JOIN | | 18948 | 943K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19161 | 580K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2005-1') ------------------------------------------------------------------------------- Object ID : 293 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): .00121 Elapsed Time (s): .150531 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2003-3') ------------------------------------------------------------------------------- Object ID : 294 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): .001316 Elapsed Time (s): .149054 CPU Time (s): .15181 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: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2004-1') ------------------------------------------------------------------------------- Object ID : 264 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): .001353 Elapsed Time (s): .148892 CPU Time (s): .157809 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: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2002-2') ------------------------------------------------------------------------------- Object ID : 283 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): .001291 Elapsed Time (s): .148217 CPU Time (s): .15181 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: 4821 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| | 4821 (1)| 00:00:01 | |* 1 | VIEW | | 18948 | 1443K| | 4821 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | |* 4 | HASH JOIN | | 18948 | 943K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19161 | 580K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='1997-1') ------------------------------------------------------------------------------- Object ID : 266 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): .001208 Elapsed Time (s): .146791 CPU Time (s): .154643 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='1995-3') ------------------------------------------------------------------------------- Object ID : 269 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): .001393 Elapsed Time (s): .14631 CPU Time (s): .15281 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: 4821 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| | 4821 (1)| 00:00:01 | |* 1 | VIEW | | 18948 | 1443K| | 4821 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 18948 | 943K| 1208K| 4821 (1)| 00:00:01 | |* 4 | HASH JOIN | | 18948 | 943K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19161 | 580K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 90 | 1350 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2002-1') ------------------------------------------------------------------------------- Object ID : 268 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): .001584 Elapsed Time (s): .145742 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: 16 Fetches: 16 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2000-2') ------------------------------------------------------------------------------- Object ID : 255 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): .001618 Elapsed Time (s): .145142 CPU Time (s): .160309 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='1998-3') ------------------------------------------------------------------------------- Object ID : 251 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): .00181 Elapsed Time (s): .144521 CPU Time (s): .167807 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='1997-4') ------------------------------------------------------------------------------- Object ID : 276 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): .001287 Elapsed Time (s): .144492 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: 15 Fetches: 15 Executions: 1 End of Fetch Count: 1 Optimizer Cost: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='1999-3') ------------------------------------------------------------------------------- Object ID : 275 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): .002005 Elapsed Time (s): .141465 CPU Time (s): .146144 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: 4829 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| | 4829 (1)| 00:00:01 | |* 1 | VIEW | | 19159 | 1459K| | 4829 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19159 | 954K| 1216K| 4829 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19159 | 954K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19374 | 586K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 91 | 1365 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='2000-1') ------------------------------------------------------------------------------- Object ID : 242 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): .00112 Elapsed Time (s): .139311 CPU Time (s): .222966 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: 4831 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| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19370 | 1475K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK| | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19370 | 964K| 1232K| 4831 (1)| 00:00:01 | |* 4 | HASH JOIN | | 19370 | 964K| | 4336 (1)| 00:00:01 | |* 5 | HASH JOIN | | 19587 | 592K| | 3139 (1)| 00:00:01 | |* 6 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | | 8 | TABLE ACCESS FULL | CUSTOMERS | 162K| 3175K| | 1197 (1)| 00:00:01 | --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 4 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") 5 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 6 - access("TIMES"."CALENDAR_QUARTER_DESC"='1995-4') ------------------------------------------------------------------------------- Object ID : 277 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): .001065 Elapsed Time (s): .115812 CPU Time (s): .119356 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: 4831 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: 3363775485 ---------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 19264 | 1467K| | 4831 (1)| 00:00:01 | |* 1 | VIEW | | 19264 | 1467K| | 4831 (1)| 00:00:01 | |* 2 | WINDOW SORT PUSHED RANK | | 19264 | 959K| 1224K| 4831 (1)| 00:00:01 | | 3 | HASH GROUP BY | | 19264 | 959K| 1224K| 4831 (1)| 00:00:01 | | 4 | NESTED LOOPS | | | | | | | | 5 | NESTED LOOPS | | 19264 | 959K| | 4336 (1)| 00:00:01 | |* 6 | HASH JOIN | | 19480 | 589K| | 3139 (1)| 00:00:01 | |* 7 | INDEX RANGE SCAN | IDX$$_00A90001 | 92 | 1380 | | 2 (0)| 00:00:01 | | 8 | TABLE ACCESS FULL | SALES | 1472K| 22M| | 3134 (1)| 00:00:01 | |* 9 | INDEX UNIQUE SCAN | CUSTOMERS_PK | | | | | | | 10 | TABLE ACCESS BY INDEX ROWID| CUSTOMERS | 1 | 20 | | 1197 (1)| 00:00:01 | ---------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("RANK_WITHIN_QUARTER"<16) 2 - filter(RANK() OVER ( PARTITION BY "TIMES"."CALENDAR_QUARTER_DESC" ORDER BY SUM("AMOUNT_SOLD") DESC )<16) 6 - access("TIMES"."TIME_ID"="SALES"."TIME_ID") 7 - access("TIMES"."CALENDAR_QUARTER_DESC"='2014-4') 9 - access("SALES"."CUST_ID"="CUSTOMERS"."CUST_ID") ------------------------------------------------------------------------------- Object ID : 249 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 : 262 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 : 263 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 : 265 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 : 272 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 : 281 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 : 282 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 : 285 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 : 287 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 : 288 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 : 291 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 : 292 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 : 296 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. -------------------------------------------------------------------------------