Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Indexing Question

Indexing Question

From: <kevin.james.campbell_at_medtronic.com>
Date: 1997/11/04
Message-ID: <345F599D.388D@medtronic.com>#1/1

I have an ORACLE SQL statement that is in need of one or more indexes. My indexing abilities are minimal. Would someone please give me some suggestions for an index or indexes? Also, would you please describe the reason for indexing the suggested way. Any suggestions on a good book on ORACLE for developers?

SELECT 	C.CONTACT_DATE, 
	C.START_TIME,
	C.END_TIME,
	C.USERIDK,
	U.CUSTNAME,
	C.CONTACT_ID,
	C.NAME,
	T.TYPE,
	A.CUSTNAME
FROM 	CONTACT C,  
	CUSTOMER U,
	TYPE T,
	CALLER A 
WHERE ( C.CUSTNO = U.CUSTNO (+) )   
	AND ( C.TYPE_ID = T.TYPE_ID (+))  
	AND ( C.CALLER_ID = A.CALLER_ID (+))  
	AND ( C.USERIDK = 'TESTER' )   
	AND ( TO_DATE ( C.CONTACT_DATE, 'DD-MON-YY' ) >= '03-OCT-97')  
	AND ( TO_DATE ( C.CONTACT_DATE, 'DD-MON-YY' ) <= '03-OCT-97') 	
	AND ( UPPER(U.CUSTNAME) LIKE Upper ( 'CAM%' ))
	ORDER BY C.CONTACT_DATE DESC, C.START_TIME DESC, C.NAME ASC

Thanks in Advance,
Kevin Received on Tue Nov 04 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US