OraFAQ Forum: Performance Tuning » The column name in user_ind_colums shows a SYS

Home » RDBMS Server » Performance Tuning » The column name in user_ind_colums shows a SYS_ name when function based index created (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

The column name in user_ind_colums shows a SYS_ name when function based index created [message #330661]

Mon, 30 June 2008 13:32

DRDBA
Messages: 22
Registered: March 2007

Junior Member

SQL> create index sno_idx on test_index(sno) tablespace users;

Index created.

Elapsed: 00:00:00.53
SQL> create index function_based_index on test_index(to_char(d_date,'dd-mm-yyyy'));

Index created.

Elapsed: 00:00:01.93

SQL> select index_name,column_name from user_ind_columns where table_name='TEST_INDEX';

INDEX_NAME COLUMN_NAME
------------------------------ ----------------------
SNO_IDX SNO
FUNCTION_BASED_INDEX SYS_NC00004$
Elapsed: 00:00:00.92

Is this a normal behavior ?
How would we query on which column the function based index is created ?
Do I need to query from a differnt view ?

Thanks
Ram

Report message to a moderator