BigBoote66_at_hotmail.com wrote:
>>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
No. Certainly they are not the silver bullet solution usable in ALL
situations ... but no.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Apr 11 2005 - 10:57:16 CDT
