Re: [?] Designer Repository Performance
From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 04 Jun 1999 13:20:44 +0200
Message-ID: <3757B68C.DA836E19_at_vnl.nl>
Date: Fri, 04 Jun 1999 13:20:44 +0200
Message-ID: <3757B68C.DA836E19_at_vnl.nl>
To add to all that (or did I miss it in the storm of advise, to which I
can only agree):
Designer V1.x is rule based - IF you have analyzed your tables, DROP
STATISTICS!!!
I've seen CASE and Des2K operations gone from 10-20 minutes back to
seconds!
Designer V2.x is cost based - estimate or compute statistics, using the
RAU. It will
only analyse the Designer Tables. Do it on a regular basis.
"Bradley G. Smith" wrote:
> On Wed, 2 Jun 1999 13:28:59 -0500, Chana Campos wrote:
>
> >Hope this helps a bit...let me know if you need further details...
>
> Wow! Thanks for the advice. Many thanks.
>
> Brad
-- Met vriendelijke groet, kind regards, Frank van Bortel Technical consultant Oracle V&L Informatica BV ----------------------------------------------- Work Home Postbus 545 Hunzestraat 4 7500 AM Enschede 7555 WB Hengelo (31)53.434.1500 (31)74.242.5046Received on Fri Jun 04 1999 - 13:20:44 CEST