重建索引

sql:

查询对象的索引：
SELECT * FROM dba_indexes where table_owner='PAYMENT' and table_name='OT_TRANS';

sql:

重建索引：
ALTER INDEX IDX_CHECK_TRANS REBUILD ONLINE PARALLEL 4;