分区表和全局索引

1.select index_name,index_type,table_owner,uniqueness,status,a.partitioned  from user_indexes a where a.table_name='BP_LINKMSG_TB';

SQL> select index_name,index_type,table_owner,uniqueness,status,a.partitioned  from user_indexes a where a.table_name='BP_LINKMSG_TB';

INDEX_NAME                INDEX_TYPE    TABLE_OWNER   UNIQUENES STATUS   PAR
------------------------------ --------------------------- ------------------------------ --------- -------- ---
PK_02                NORMAL    SUNDS       UNIQUE    VALID    NO
SYS_IL0000129883C00003$$       LOB        SUNDS       UNIQUE    N/A      YES



2. 查询分区

explain plan for select * from BP_LINKMSG_TB a where a.tran_date>=to_date('2018-05-31 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
and a.tran_date<=to_date('2018-06-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss');


select * from table(dbms_xplan.display());

PLAN_TABLE_OUTPUT
Plan hash value: 3191706964

--