oracle检查索引的工具,ORACLE 经常使用的命令工具-第四章:索引

第四章:索引

z6L`"|+}2~0　　1.creating function-based indexes51Testing软件测试网-S2^5M7xsxF

51Testing软件测试网!{%x6q[-jXO4CP

a

sql> create index summit.item_quantity on summit.item(quantity-quantity_shipped);51Testing软件测试网5CQ$R1W$o_(?

X(GPM7^&i0　　2.create a B-tree index51Testing软件测试网{Y4^mD,XlH;F

p4n{|+[]l(V0　　sql> create [unique] index index_name on table_name(column,.. asc/desc) tablespace51Testing软件测试网/OqK A5KzF5@IkHi#r

EB.e]/nl0　　sql> tablespace_name [pctfree integer] [initrans integer] [maxtrans integer],q6\y$m?YN3Nl&[0

51Testing软件测试网7A*k?%?U@

sql> [logging | nologging] [nosort] storage(initial 200k next 200k pctincrease 051Testing软件测试网N!{i;YB

51Testing软件测试网D@*Le|!RJ3I)e.L

sql> maxextents 50);x'_.B]#}nP0

51Testing软件测试网jIthVX0G

3.pctfree(index)=(maximum number of rows-initial number of rows)*100/maximum number of rowsl#u _2GM2oaJ0

51Testing软件测试网!u3|&n