Hi
I create a table as follows:
create table a ( a number(1));
Then I create index as :
create index ia on a(a desc);
If i see the index columns as :
select index_name, table_name, column_name, column_position from
all_ind_columns where table_name = 'A';
index_name table_name
:
Sent by: Subject: desc order index
[EMAIL PROTECTED
That's normal for a DESCending index, as Oracle creates a function-based
index for this.
Check all|user|dba_ind_expressions for the column name in column_expression.
- Kirti
-Original Message-
Sent: Tuesday, October 22, 2002 8:59 AM
To: Multiple recipients of list ORACLE-L
Hi
I
Rahul Mehendale wrote:
Hi
I create a table as follows:
create table a ( a number(1));
Then I create index as :
create index ia on a(a desc);
If i see the index columns as :
select index_name, table_name, column_name, column_position from
all_ind_columns where table_name =