记忆-oracle-执行计划查看

1 数据创建 

create table test_index(id int primary key,v int )
create index test_index_v_desc on test_index(v)

2 数据输入

declare 
a int:=0;
begin
  while (a < 100) loop
    insert into test_index(id,v) values(a,a);
    a:=a+1;
    end loop;
end;

3 执行计划查看

3.1.计划：全表查询

explain plan for
select * from test_index 

select * from table(dbms_xplan.display)

 3.2.计划：使用索引

explain plan for
select * from test_index where v=100

 

select * from table(dbms_xplan.display)