[oracle]创建查看 LOCAL INDEX

[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

 

[oracle]创建查看 LOCAL INDEX,布布扣,bubuko.com

[oracle]创建查看 LOCAL INDEX

上一篇:oracle


下一篇:vs2010 win32程序中 sqlserver 2008 express的简单使用 (C++)