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: Are Oracle DBAs trivialized?

Re: Are Oracle DBAs trivialized?

From: <BigBoote66_at_hotmail.com>
Date: 11 Apr 2005 08:30:44 -0700
Message-ID: <1113233444.942242.59530@o13g2000cwo.googlegroups.com> 





> I get apps tossed at me with hundreds of poorly written queries

> (correlated subqueries everywhere, NOT EXISTS, etc.) that I have to

> rewrite for speed.




Just curious, why does the presence of correlated subqueries or NOT
EXISTS clauses equate to a poorly written query?  As a DBA & developer,
I've used them quite frequently and they perform just fine.  Is there a
more efficient alternative?



-Steve
Received on Mon Apr 11 2005 - 10:30:44 CDT












Original text of this message













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