Saturday, February 21, 2015

Details of all user indexes

SELECT INDEX_NAME, INDEX_TYPE, TABLE_NAME, UNIQUENESS, COMPRESSION, TABLESPACE_NAME, STATUS FROM USER_INDEXES

No comments:

Post a Comment