本帖最后由 hedvahu 于 2017-9-7 16:16 编辑
现有下列sql语句,在不同的环境下执行,显示的执行计划不同,不知道什么原因:
1.STAFF 员工表 索引 party_id
2.PARTY_CONTACT_INFO 记录员工电话号码,索引 party_id
sql语句如下:
select *
from STAFF js
left join PARTY_CONTACT_INFO jpci
on js.party_id = jpci.party_id;
在测试环境的执行计划:
---------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 113K| 436M| 42882 (1)| 00:08:35 |
| 1 | NESTED LOOPS OUTER | | 113K| 436M| 4