原SQL语句如下:
update Tindex a set a.object_type='SPECIAL' where a.object_type is not null
and exists (select 1 from Tindex b where b.object_name='TINDEX'
and a.object_name=b.object_name)
使用以下语句查看当前游标执行计划,和预期的不一样
select * from table(dbms_xplan.display_cursor('55j33gdu4qx7g'));
用explain plan fo