摘要:
一、本文说明: 操作系统:rhel 5.4 x32 数据库:oracle 11g r2 x32二、实验内容: ----创建一张jack表,并创建索引jack_ind---- 1 SQL> create table jack as select * from dba_objects; 2 3 Table created. 4 5 SQL> create index jack_ind on jack(object_id); 6 7 Index created. 8 ----先做一下统计信息,并连带索引---- 9 SQL> exec dbms_stats.gather... 阅读全文