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 -> SQL optimisation

SQL optimisation

From: Monty <mmontreaux_at_hotmail.com>
Date: 26 Nov 2002 13:13:05 -0800
Message-ID: <6284dd3.0211261313.5c5eebdb@posting.google.com> 





Excuse me all but I am writing/optimising considerable amounts of SQL
written for Oracle 7 to be deployed on an Oracle 9 database. Some of
the queries are very complex and verbose, > 900-100 characters.



Might I ask the opinions of the forum as to what applications are
there out there that could be used to analyse existing queries and
propose alternate and more efficient constructs.



Thank you


Monty.
Received on Tue Nov 26 2002 - 15:13:05 CST












Original text of this message













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