Re: Tunning help

From: Fred Puhan <f_puhan_at_precise.com>
Date: Fri, 07 Jun 2002 19:54:24 -0400
Message-ID: <f_puhan-BBCD14.19542407062002@vienna7.his.com>

In article <b7616278.0206071406.317b3105_at_posting.google.com>, sasubram_at_cisco.com (shankar) wrote:

> Hello,
> I have a query which runs in less than 200 msc without order by clause.
> But as soon as I add the order by clause it runs for 16 to 19 seconds
>
> is there any way I can avoid the order by?
> Users really need to order the result in certain way.
>
> any tuning suggestion?

You don't give us any indication of which version of Oracle you're using, so assistance will be limited. Future note: it ALWAYS benefits to provide as much environmental information as possible, as diagnosis in a "blind" situation is virtually useless.

Is there an index on the key column to which you want the results ordered? Can you recreate the table as Index-organized? How large is the table?

You see, there's just so little to suggest given the information you've provided.

-- 
The underscore character does not belong in my address. You know the drill...

Received on Fri Jun 07 2002 - 18:54:24 CDT