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: High CPU Query

Re: High CPU Query

From: <stevedhoward_at_gmail.com>
Date: 31 Mar 2006 13:19:43 -0800
Message-ID: <1143839983.802992.281020@z34g2000cwc.googlegroups.com> 





Time and time again, I have found the best way to tame one of these
beasts is to break it up into manageable pieces.  When you do that, you
usually find the problem child very quickly.  Split the unions into two
statements and run each separately, break out the IN's, etc., to see
what falls out.



Regards,



Steve
Received on Fri Mar 31 2006 - 15:19:43 CST












Original text of this message













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