Re: Performance Problems

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 20 May 2007 12:12:22 +0100
Message-ID: <UMqdnd5PmdjpsM3bnZ2dnUVZ8sCsnZ2d@bt.com>

"Mladen Gogala" <mgogala.SPAM_ME.NOT_at_verizon.net> wrote in message news:pan.2007.05.16.11.55.26_at_verizon.net...
> On Wed, 16 May 2007 02:35:04 -0700, mjmather wrote:
>
>> Anyone have suggestions, comments or considerations?
>
> Cluster the tables.
>
> --
> http://www.mladen-gogala.com

Mladen,

You missed a critical point in the original post:

> I can
> change / alter
> Package table but I have select only permission on Audit_Trail as it's
> in the schema of a 3rd party product.
>

(He also needs to change the definition of the package table so that the tables have a common cluster definition, but he is allowed to do that)

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Sun May 20 2007 - 06:12:22 CDT