Re: Oracle 9i usage question

Raghvendra Sharma wrote:
> Hi All,
>
> We recently migrated to 9i from 8i (8.1.7.4)
>
> Lets say T1 and T2 both have a join key column called root_key. In
one
> table the datatype ofr the column is varchar2(50) and in the other
one
> its number(18). The content is just fine.

What are the tables structures. Primary keys? foreign keys?

> the application uses heavily the join on these two tables. Till
Oracle
> 8i, this join condition was resolved using appropriate indexes built
> on these two tables.

What indexes (on which columns)?

> However, during our tests also and since last two days on ACCEPT
also,
> the explain plan does not use the index on tables. Instead it goes
for
> a FTS.

could you post the SQL you are testing? maybe the explain plan too?

Regards,
Koki Received on Tue May 03 2005 - 19:02:29 CDT