Re: Semi-OT: It's the Code, Stupid!

From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
To: Rich.Jesse@xxxxxxxxxxxxxxxxx
Date: Thu, 02 Jun 2005 20:24:03 +0200

Having presented something a few years ago at the UKOUG conference and 
at a NYOUG meeting under a very similar name (I had used 'algorithm' 
instead of 'code') I can only applaud with both hands.

 By a strange coincidence, I have been asked (towards the end of the day 
- east of Greenwich, here) to have a look at an INSERT ... SELECT ... 
which runs every hour and takes increasingly longer (15 minutes right 
know and it it seems to become a very hot topic). The SELECT is a SELECT 
from a view, no WHERE clause. Text of the view? As you might expect, a 
view of death, with cascading EXISTS and right in the middle of the 
query ... something which is IMHO very typical of SQL Server developers 
and possibly some other people deprived of CONNECT BY (take heart, SQL 
developers, recursive WITH acoming ...), a subquery that uses this 
absolutely dreadful nested set "model", promoted so vigorously by 
someone whose name is slipping my mind at the moment. Isn't it interesting.
I have not modified it much yet, just grinding my axe before making a 
few cosmetic changes with delicacy tomorrow, first thing in the morning.

Did I mention all the tables in the query where prefixed with PS_ ?

<grin/>

Stephane Faroult

Jesse, Rich wrote:

>How's about a link?  Surf to http://www.dmreview.com and then "View Full
>Issue" under the "Current Issue of DM Review Magazine" heading in the
>middle of the page.
> 
>Rich
>       -----Original Message-----
>       From: Jesse, Rich 
>       Sent: Thursday, June 02, 2005 10:18 AM
>       To: oracle-l@xxxxxxxxxxxxx
>       Subject: Semi-OT: It's the Code, Stupid!
>       
>       
>
>       For those of you who don't get DM Review magazine, there's an
>excellent article in the June 2005 issue by Joe Celko (still here Joe?)
>called "It's the Code, Stupid!".
>       
>       It's sad when our third-party vendor's schema falls under what
>he decribes as "worst-case scenario".  <sigh>
>       
>       Rich
>       
>       Rich Jesse                        System/Database Administrator
>       rich.jesse@xxxxxxxxxxxxxxxxx      QuadTech, Sussex, WI USA
>         
>
>
>--
>//www.freelists.org/webpage/oracle-l
>
>  
>


--
//www.freelists.org/webpage/oracle-l

References:
- RE: Semi-OT: It's the Code, Stupid!
  - From: Jesse, Rich

Re: Semi-OT: It's the Code, Stupid!

Other related posts: