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: Horrible Query Performance, Simple Query -- Performance Tuning Help Needed

Re: Horrible Query Performance, Simple Query -- Performance Tuning Help Needed

From: WhiteDog <cchenoweth56_at_msn.com>
Date: 19 Apr 2006 15:15:37 -0700
Message-ID: <1145484937.572607.312790@i40g2000cwc.googlegroups.com> 





The HDD_Tran_2000 function is run all over the place (it basically gets
the report name for the ID).  I've removed it from the query and it
still takes 27 seconds to run.  I don't have the SQL for it, but I can
get it if needed.
Received on Wed Apr 19 2006 - 17:15:37 CDT












Original text of this message













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