Q:请问什么是explain plan?
A:用system用户运行$ORACLE_HOME/rdbms/admin/utlxplan.sql脚本生成plan_table表
create public synonym plan_table for plan_table;
grant select,update,insert,delete on plan_table to public;
A:用system用户运行$ORACLE_HOME/rdbms/admin/utlxplan.sql脚本生成plan_table表
create public synonym plan_table for plan_table;
grant select,update,insert,delete on plan_table to public;