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.'
>
Oracle LazyDBA home page