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

Home -> Community -> Usenet -> c.d.o.misc -> Re: DBA HELP: Performane Tune SELECT, SUM, & CASE

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@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 - 00:50:00 CDT

Original text of this message

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