| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Please Help: Sudden Drop in SQL Performance
SELECT DISTINCT EMPLID, EMPL_RCD#, NAME, SSN FROM PS_FSA_HC_SRCH WHERE
EMPLID LIKE '12900%' AND OPRCLASS='ALLPANLS' ORDER BY EMPLID;
Oracle Can choose to use the index on EMPLID or the index on ORPCLASS
The powserfull is the first one. Check with typing "Set sqltrace=true" at sqlplus prompt if Oracle uses the correct index You should certainly have to create the plan table ($ORACLE_HOME/rdbms/admin/utlxplan.sql) before setting the sqltrace variable.
Send us the execution plan... Received on Wed Jan 12 2000 - 02:52:51 CST
 |
 |