Oracle internal
-
编辑 删除
BTree索引dump
一，创建测试表并且收集统计信息。SQL> create table test as select*from sales;Table created.SQL> create index test_inx1 on test(prod_id,cust_id,time_id,channel_id);Index created.SQL> begin 2 dbms_stats.gather_table_stats(ownname =>'SH', 3 tabname =>'TEST',[@more@]4 estimate_percent =>40, 5 method_opt =>'for all columns size auto', 6
