检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
To delete the subplan, modify the statement as follows: 1 explain(costs off) select * from t1 where exists (select 1 from t2 where t1.c1 = t2.c1 and t1.c2 = t2.c2); In this way, the subplan is replaced by the semi-join between the two tables, significantly improving the execution
Non-reserved Reserved Reserved DECODE Non-reserved (cannot be a function or type) - - DEFAULT Reserved Reserved Reserved DEFAULTS Non-reserved - - DEFERRABLE Reserved Reserved Reserved DEFERRED Non-reserved Reserved Reserved DEFINED - Non-reserved - DEFINER Non-reserved Non-reserved - DELETE
