When describe a talbe to get the structure information, I also hope to display the indexes information. In AnySQL, I wrote the DESCRIBE command with this feature. It really save me a lot of time to write SQLs when performing SQL turning works.
For example :
ASQL> desc sh.t_longraw
NO# NAME NULLABLE TYPE
--- ---------------- -------- ------
1 COL1 NOT NULL NUMBER
2 COL2 BLOB
TYPE ISUNQ INDEX_NAME NO# COLUMN_NAME DESCEND
------ ------ ------------------ --- ----------- -------
NORMAL UNIQUE SYS_C003768 1 COL1 ASC
PARTITIONED AVG_ROW_LEN NUM_ROWS BLOCKS EMPTY_BLOCKS
----------- ----------- -------- ------ ------------
NO 0 0 4 0
Many DBAs will use GUI tool to get these information, but I like character command interface for high efficiency.