Oracle Star Schema简析(三)
| |
| 19 | BITMAP KEY ITERATION | |
| | | | | |
| 20 | BUFFER SORT | |
| | | | | |
|* 21 | TABLE ACCESS FULL | TIMES | 1
83 | 2928 | 15 (0)| 00:00:01 | | |
|* 22 | BITMAP INDEX RANGE SCAN | SALES_TIME_BIX |
| | | |KEY(SQ)|KEY(SQ)|
| 23 | BITMAP MERGE | |
| | | | | |
| 24 | BITMAP KEY ITERATION | |
| | | | | |
| 25 | BUFFER SORT | |
| | | | | |
| 26 | TABLE ACCESS FULL | SYS_TEMP_0FD9D660B_7E653 |
1 | 13 | 2 (0)| 00:00:01 | | |
|* 27 | BITMAP INDEX RANGE SCAN | SALES_CUST_BIX |
| | | |KEY(SQ)|KEY(SQ)|
| 28 | TABLE ACCESS FULL | SYS_TEMP_0FD9D660B_7E653 | 3
83 | 5745 | 2 (0)| 00:00:01 | | |
|* 29 | TABLE ACCESS FULL | CHANNELS |
2 | 42 | 3 (0)| 00:00:01 | | |
----------------------------------------------------
www.2cto.com
----------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
3 - filter("C"."CUST_STATE_PROVINCE"='CA')
5 - access("S"."CHANNEL_ID"="CH"."CHANNEL_ID")
6 - access("S"."CUST_ID"="C0")
7 - access("S"."TIME_ID"="T"."TIME_ID")
8 - filter("T"."CALENDAR_QUARTER_DESC"='1999-Q1' OR "T"."CALENDAR_QUARTER_DES
C"='1999-Q2')
16 - filter("CH"."CHANNEL_DESC"='Catalog' OR "CH"."CHANNEL_DESC"='Internet')
17 - access("S"."CHANNEL_ID"="CH"."CHANNEL_ID")
21 - filter("T"."CALENDAR_QUARTER_DESC"='1999-Q1' OR "T"."CALENDAR_QUARTER_DES
C"='1999-Q2')
22 - access("S"."TIME_ID"="T"."TIME_ID")
27 - access("S"."CUST_ID"="C0")
29 - filter("CH"."CHANNEL_DESC"='Catalog' OR "CH"."CHANNEL_DESC"='Internet')
从上面执行计划可以看出，此SQL语句做了star transformation. 走了BITMAP索引，例如：BITMAP MERGE ,BITMAP AND等等。