Re: index usage---

Andre Weber wrote:
>
> Hello,
>
> i have a little trouble with indizes on Oracle 8.1.5 --- why doesn't Oracle
> use my Indizes?
>
> the following situation:
>
> 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%';
>
> explain plan allways shows me that a Fulltable-Scan is performed?
> why?
>
> Every hint? is welcome
>
> bye
> André

See the link on my site about the privs you need to create function based indexs...

hth
connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"