SELECT /*+ gather_plan_statistics monitor bind_aware */ s1.channel_id, SUM(p.prod_list_price) price FROM products p, sales s1, sales s2 WHERE s1.cust_id = :b1 AND s1.prod_id = p.prod_id AND s1.time_id = s2.time_id GROUP BY s1.channel_id
Global Information: DONE (ALL ROWS)Instance ID | : | 1 |
|
|||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Session | : | SH (24:12753) | ||||||||||||||
SQL ID | : | 434kpwwbqamfd | ||||||||||||||
SQL Execution ID | : | 16777219 | ||||||||||||||
Execution Started | : | 02/04/2013 09:41:19 | ||||||||||||||
First Refresh Time | : | 02/04/2013 09:41:19 | ||||||||||||||
Last Refresh Time | : | 02/04/2013 09:41:24 | ||||||||||||||
Duration | : | 5s | ||||||||||||||
Module/Action | : | SQL*Plus/- | ||||||||||||||
Service | : | SYS$USERS | ||||||||||||||
Program | : | sqlplus@host01.example.com (TNS V1-V3) | ||||||||||||||
Fetch Calls | : | 2 |
Name | Position | Type | Value |
---|---|---|---|
:B1 | 1 | NUMBER | 10 |
Id | Operation | Name |
Estimated
Rows |
Cost |
Active Period
(5s) |
Execs | Rows |
Memory
(Max) |
Temp
(Max) |
IO Requests | CPU Activity | Wait Activity | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
. |
0 | SELECT STATEMENT |
. |
. |
. |
|
1 | 2 |
. |
. |
|
. |
. |
||||||
. |
1 | . HASH GROUP BY |
. |
4 | 118 |
|
1 | 2 | 503.0KB |
. |
|
. |
. |
||||||
. |
2 | .. HASH JOIN |
. |
130 | 117 |
|
1 | 165 | 1.1MB |
. |
|
. |
. |
||||||
. |
3 | ... JOIN FILTER CREATE | :BF0000 | 130 | 58 |
|
1 | 165 |
. |
. |
|
. |
. |
||||||
. |
4 | .... HASH JOIN |
. |
130 | 58 |
|
1 | 165 | 1.2MB |
. |
|
. |
. |
||||||
. |
5 | ..... TABLE ACCESS FULL | PRODUCTS | 72 | 3 |
|
1 | 72 |
. |
. |
|
. |
. |
||||||
. |
6 | ..... PARTITION RANGE ALL |
. |
130 | 55 |
|
1 | 165 |
. |
. |
|
. |
. |
||||||
. |
7 | ...... TABLE ACCESS BY LOCAL INDEX ROWID | SALES | 130 | 55 |
|
28 | 165 |
. |
. |
|
. |
. |
||||||
. |
8 | ....... BITMAP CONVERSION TO ROWIDS |
. |
. |
. |
|
16 | 165 |
. |
. |
|
. |
. |
||||||
. |
9 | ........ BITMAP INDEX SINGLE VALUE | SALES_CUST_BIX |
. |
. |
|
16 | 4 |
. |
. |
|
. |
. |
||||||
. |
10 | ... VIEW | VW_GBF_9 | 1460 | 58 |
|
1 | 28 |
. |
. |
|
. |
. |
||||||
. |
11 | .... HASH GROUP BY |
. |
1460 | 58 |
|
1 | 28 | 1.2MB |
. |
|
. |
. |
||||||
. |
12 | ..... JOIN FILTER USE | :BF0000 | 919K | 58 |
|
1 | 16548 |
. |
. |
|
|
|
||||||
. |
13 | ...... PARTITION RANGE ALL |
. |
919K | 58 |
|
1 | 919K |
. |
. |
|
|
|
||||||
. |
14 | ....... BITMAP CONVERSION TO ROWIDS |
. |
919K | 58 |
|
28 | 919K |
. |
. |
|
. |
. |
||||||
. |
15 | ........ BITMAP INDEX FULL SCAN | SALES_TIME_BIX |
. |
. |
|
28 | 1460 |
. |
. |
|
. |
. |