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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Query Performance

Re: Query Performance

From: Bricklen <Xbricklen_at_yahoo.comX>
Date: Tue, 27 Jul 2004 03:03:41 GMT
Message-ID: <hCjNc.122661$ek5.104400@pd7tw2no>


MP wrote:

> How do I increase the performance of a SELECT query with GROUP BY clause?
>
>

That spartan question will not get you many helpful responses. Oracle version?
Post the query, or an approximation. Have you generated statistics? Have you looked at the Explain Plan? Any other details that you care to share will likely help. Received on Mon Jul 26 2004 - 22:03:41 CDT

Original text of this message

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