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

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent Tuning Question....

Re: Urgent Tuning Question....

From: alek <alexandru.tica_at_gmail.com>
Date: 10 May 2006 05:29:49 -0700
Message-ID: <1147264189.095313.26590@i39g2000cwa.googlegroups.com> 





Hi,



Hard to say... Can you provide the structure of the involved tables?
Have you collected statistics using ANALYZE or DBMS_STATS package? How
about creating an index on:


js.jsu_start_date


rt.jsu_rate


jsu_payment_code (?)


pm.payment_code


pm.real_payment_code.



I would also suggest you to take care of the type of the variables used
in the WHERE clause of your select. They should match.



Cheers!


alec.
Received on Wed May 10 2006 - 07:29:49 CDT












Original text of this message













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