-
创建测试表
以用户jyu连接,创建测试表
SQL> conn jyu/jyu;
Connected.
SQL> create table t (id number, name varchar2(100));
Table created.
SQL> insert into t select rownum,object_name from dba_objects;
47391 rows created.
SQL> commit;
Commit complete.
创建索引
SQL> create index t_idx1 on t(id);
Index created.
收集统计数据
SQL> exec dbms_stats.gather_table_stats('JYU','T');
PL/SQL procedure successfully completed.以用户jyu连接,创建测试表
SQL> con