Re: DBA HELP: Performane Tune SELECT, SUM, & CASE
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 20 Apr 2005 22:50:00 -0700
Message-ID: <1114062364.804426_at_yasure>
Date: Wed, 20 Apr 2005 22:50:00 -0700
Message-ID: <1114062364.804426_at_yasure>
gilgantic wrote:
> HELP!!!
>
> I am trying to fine tune or rewrite my SELECT statement which has a
> combination of SUM and CASE statements. The values are accurate, but
> the query is slow.
Lets see ... you posted this to pretty much every usenet group you could spell. Generic "databases", "theory", "IBM-DB2", "Oracle".
When you decide which product you are using
And you provide a version number
And you provide an SLA
And you provide, assuming Oracle, an explain plan,
Help may be possible.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Thu Apr 21 2005 - 07:50:00 CEST