Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Indexing Question
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
![]() |
![]() |