I would just add a column that is valued by setting it equal to
upper(customer.enterprisename), then make an index on it.




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