select /*+ ALL_ROWS NO_MERGE(A) NO_MERGE(B) USE_HASH(A B) */a.OWNER "Owner", a.INDEX_NAME "Index Name", a.INDEX_TYPE "Index Type", a.TABLE_OWNER "Table Owner", a.TABLE_NAME "Table Name", a.UNIQUENESS "Uniqueness", DECODE(a.COMPRESSION, 'DISABLED', NULL, 'COMPRESS ' || TO_CHAR(a.PREFIX_LENGTH) ) "Compress", B.SEG_SIZE "Index Size(KB)", A.LEAF_BLOCKS "Index Leaf Blocks", EXT_BLOCKS "Frag Blocks", ..