Hi all

I am having Query like this by creating the Index on CUSTOMER.ENTERPRISENAME can i avoid the
FULL 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

Thanx
Ramki


-------------------------------------------------------
'Believe in what you do and do what you believe in.'

Oracle LazyDBA home page