That's true. In 8i, Oracle introduced function-based
indexes to the stable.

--- Peter Bubeliny <[Email Address Removed] wrote:
> Regarding 1, I read somewhere (I am pretty sure it
> was Oracle9i
> documentation - I am not sure which version of
> Oracle you are running)
> that now (from that version on) it is possible to
> create an index on
> expression involving also SQL function.
> HTH,
>
> Peter
>
> ramki wrote:
>
> > Hi all I am having Query like this by creating the
> Index on
> > CUSTOMER.ENTERPRISENAME can i avoid theFULL Scan
> of the table but
> > here thier are two problems . 1 Creating a Index
> on ENTERPRISENAME
> > alone will not work as long as UPPER function is
> there in select
> > 2.Usage of OR SELECT CUSTOMER.CUSTOMERID,
> CUSTOMER.FIRSTNAME,
> > CUSTOMER.MIDDLENAME,
> > CUSTOMER.LASTNAME, CUSTOMER.ENTERPRISENAME,
> CUSTOMER.SSN,
> > CUSTOMER.FEDERALTAXID, CUSTOMER.GOVERNMENTAGENCY,
> CUSTOMER.ADDRESSID,
> >
> > CUSTOMER.CUSTOMERTYPE, ESP.ESPID, ESP.NAME,
> ESP.STATUS,
> > ESP.DESCRIPTION
> > FROM CUSTOMER, ESP WHERE CUSTOMER.ESPID =
> ESP.ESPID(+) AND
> > CUSTOMER.CUSTOMERTYPE='B' AND (
> UPPER(CUSTOMER.ENTERPRISENAME) like
> > 'NET2001%' OR CUSTOMER.FEDERALTAXID = '' ) order
> by
> > customer.FIRSTNAME asc plz guide me how to go
> through
> > this ThanxRamki
>
-------------------------------------------------------
> >
> > 'Believe in what you do and do what you believe
> in.'
> >
>


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
Oracle LazyDBA home page