[oracle]创建查看 LOCAL INDEX

 

create index IDX_T_GPS_CPH_local on T_GPS (CPH) local;

create index IDX_T_GPS_SJ_local on T_GPS (SJ) local;

 select * from dba_ind_partitions where index_owner ='GPSV4_HIS' order by partition_name

 从结果推看，建立Local索引时如果不指定分区，则每个分区上都建立一个。

-----------

http://blog.csdn.net/jackpk/article/details/3788445 

创建查看和浅析LOCAL INDEX和GLOBAL INDEX