Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Semi-OT: It's the Code, Stupid!

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

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Thu, 02 Jun 2005 20:24:03 +0200
Message-ID: <429F4EC3.4070506@roughsea.com>


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_at_freelists.org
> 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_at_quadtechworld.com QuadTech, Sussex, WI USA
>
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 02 2005 - 14:28:59 CDT

Original text of this message

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