Re: Query for Top 10 Most "Expensive" Queries

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 27 Aug 2003 17:35:00 -0700
Message-ID: <R6c3b.73789$kP.22622@fed1read03>

Billy Verreynne wrote:

> alvathinstruct_at_hotmail.com (Allan Vath) wrote
>
>

>>I once had the sql which read a sys view which listed the top 10 worst
>>queries (as judged by high I/O).  

>
>
> High i/o is not indicative of bad SQL. Just as high CPU usage is not
> bad.
>
> Computer resources are there to be used. CPU, memory, i/o channels,
> network channels, etc.
>
> Computer resources sitting idle is wasting your money. Computer
> resources being used is putting your money to use.

The following a a FORTRAN statement

   10 GO TO 10

The statement above is 100% guarenteed to use CPU cycles. However, I do NOT consider it to be "putting my money to use".

Never confuse movement with progress.

Going around in circles is movement to the max. Most folks will not consider going around in circles to be progress. Received on Wed Aug 27 2003 - 19:35:00 CDT