|
N_CAL_YEAR,
SH.TIMES.END_OF_CAL_YEAR);
?
我们再次查询
?
SQL> SELECT t.calendar_quarter_id,
prod_id,
channel_id,
promo_id,
SUM (quantity_sold) quantity_sold,
SUM (amount_sold) amount_sold
FROM sales s, times t
WHERE s.time_id = t.time_id AND t.calendar_quarter_desc = '1998-01'
GROUP BY prod_id,
channel_id,
promo_id,
t.calendar_quarter_id;
168 rows selected.
Execution Plan
----------------------------------------------------------
Plan hash value: 3290467316
--------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 20 | 2240 | 33 (7)| 00:00:01 |
| 1 | HASH GROUP BY | | 20 | 2240 | 33 (7)| 00:00:01 |
|* 2 | HASH JOIN | | 17191 | 1880K| 32 (4)| 00:00:01 |
| 3 | VIEW | VW_GBF_5 | 91 | 3094 | 19 (6)| 00:00:01 |
| 4 | HASH GROUP BY | | 91 | 728 | 19 (6)| 00:00:01 |
| 5 | VIEW | | 91 | 728 | 19 (6)| 00:00:01 |
| 6 | HASH UNIQUE | | 91 | 1456 | 19 (6)| 00:00:01 |
|* 7 | TABLE ACCESS FULL | TIMES | 91 | 1456 | 18 (0)| 00:00:01 |
| 8 | MAT_VIEW REWRITE ACCESS FULL| SALES_MONTH_SUM | 9068 | 690K| 13 (0)| 00:00:01 |
--------------------------------------------------------------------------------------------------
?
这次就使用了物化视图。
|