17,377
社区成员
发帖
与我相关
我的任务
分享
select * from v$version;
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
"CORE 12.1.0.2.0 Production" 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
-- 应该是统计信息过旧了,手工收集一下。语法参考如下
SQL> drop table test purge ;
Table dropped
SQL> create table test(id int, name varchar(10)) ;
Table created
SQL> create index ix_test on test(id) ;
Index created
SQL> exec dbms_stats.gather_table_stats(user,'test',cascade => true);
PL/SQL procedure successfully completed
SQL> drop table test purge ;
Table dropped
SQL>