📄 demo14.sql
字号:
create table t ( x char(1) constraint t_pk primary key,
y date );
insert into t values ( '5', sysdate );
delete from plan_table;
explain plan for select * from t where x = 5;
select * from table(dbms_xplan.display);
explain plan for select /*+ INDEX(t t_pk) */ * from t
where x = 5;
select * from table(dbms_xplan.display);
delete from plan_table;
explain plan for select * from t where x = '5';
select * from table(dbms_xplan.display);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -