SQL Developer

SQL Developer 1.0.0.14.67, DB 9.2.0.5, Win XP SP 2

I have just been chasing up a performance issue and trying to see what indexes are already available on a table. The table that I am checking for indexes has a function based index, but the UI does not display the function behind the function based index simply.

The Index sub-tab of the Table tab lists the function based index and shows that it is function based, but shows the column as SYS_NC00010$ in my example (which does not appear as a column on the table). Similarly, the Column sub-tab of the corresponding Index tab lists the column as SYS_NC00010$.

However, if I go to the SQL sub-tab of either the Table or the Index tabs the function is displayed - UPPER("ALIAS_VALUE_NAME") in my example.

Rather than showing the SYS_NC00010$ column in the column details for the Index (which means nothing as this column cannot be queried through the UI), this should show the actual function instead.