Re: index usage---

"Andre Weber" <WeberAndre_at_t-online.de> wrote in message news:9bsacb$hq9$07$1_at_news.t-online.com...
> I have a table called "files" and there is a column names "ONAME" on this
> column
> i've created a Function Based Index (other Question why can't i create a
> function
> based index as normal user?)
>
> create index TEST.FILESNAMEIDX on TEST.FILES (upper(ONAME));
> (the relation files contains near 1 million records!)
>
> later in the application i have the following select (simplified)
>
> select * from FILES where upper(oname) like 'TEST%';

what is the explain plan for this simplified select - does it show a full tablescan or does it show index usage.

perhaps you could post the full sql statement and associated explain plan.

--
Niall Litchfield
Oracle DBA
Audit Commission UK