oracle 多表查询 索引,关于多表间连接查询建立索引的问题

解释计划获取:

成本 (所有行)

执行步骤:

19  SELECT STATEMENT

18  SORT (GROUP BY)

17  HASH JOIN

1  TABLE ACCESS (FULL), M_MARKET (UCADM)

16  HASH JOIN

10  HASH JOIN

8  VIEW, DV_ACCOUNTDETAIL (UCADM)

7  SORT (UNIQUE)

6  UNION-ALL

3  TABLE ACCESS (BY INDEX ROWID), D_ACCOUNTDETAIL_HIS (UCHISADM)

2  INDEX (RANGE SCAN), IDX_D_ACCOUNTDETAIL_HIS (UCADM)

5  TABLE ACCESS (BY INDEX ROWID), D_ACCOUNTDETAIL (UCADM)

4  INDEX (RANGE SCAN), IDX_D_ACCOUNTDETAIL (UCADM)

9  TABLE ACCESS (FULL), M_MARKET (UCADM)

15  VIEW, DV_OFFLINEDATA (UCADM)

14  SORT (UNIQUE)

13  UNION-ALL

11  TABLE ACCESS (FULL), D_OFFLINEDATA_HIS (UCHISADM)

12  TABLE ACCESS (FULL), D_OFFLINEDATA (UCADM)

步骤 说明 估计成本 估计行计数 估计字节计数

1 该操作将使用全表扫描检索表 M_MARKET 的所有行。 1 1 26

2 该操作通过扫描索引 IDX_D_ACCOUNTDETAIL_HIS (按关键