Check out Alberto Dell’Era’s SQL query analyzer – lots of good info like this compact table of indexes availble on the query: http://www.adellera.it/blog/2009/06/07/optimizing-sql-statements-with-xplan/
--------------------------------------
02.|ColName |1|2|3|4|5|P|U1|U2|R1|
03.--------------------U-U------------
04.|X |1|1|2|1| |1| |2 | |
05.|PADDING | | |1|2|1|2|R1|1 | |
06.|RR | | | | | | | | |1 |
07.|SYS_NC00004$|2| | | | | | | | |
08.|SYS_NC00005$| |2| | | | | | | |