Re: Indexes ignored

> Do you have a reason for using the upper function on a numeric (?) NBR
> column ?
>

NBR is a varchar2 column

> Do you have an index on the NBR column ? (else main query has no way of
> reading just the required NBR)
>

No, but I should.

> Is it a function based index, created as create index index_name on
> table_name (upper (NBR)); ? Else the upper function negates the use of a
> normal index.
>

No, this is not an Enterprise db

> Do you have a good reason for all your other indexes to be reversed
> (incrementally increasing values, high insert loads) ? Range scans can't be
> used which possibly limits their use.
>

All columns are populated by sequences.

> Have all the tables been analyzed if you are using the CBO ?
>

Yes

Thanks for your response.

-- 
Jim Poe
<jbpoe_at_pacbell.net>