Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXPLAIN PLAN : better with RULE!
Yet another $0.05
Well, isn't this what the new dynamic sampling/table monitoring/stale stats regeneration is for helping out with ....
to allow you, the expert DBA to cover for the applications.
Both DB2 and SQL Server need stats too ....
and if it's really a problem you can store the outlines anyway.
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
news:3d35310d$0$231$cc9e4d1f_at_news.dial.pipex.com...
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:8pq8jus6bt3o26h5oc1ahmlg5gaqdl2v3d_at_4ax.com...
> > On Tue, 16 Jul 2002 22:20:48 +0400, "Vladimir M. Zakharychev"
> > <bob_at_dpsp-yes.com> wrote:
> >
> > >Well, that same note states that to Oracle knowledge close to 80% of
> > >all vendors already made their applications at least CBO-aware (while
> > >they are not saying those applications are all tuned to make good use
> > >of CBO.) ;)
> >
> >
> > So it appears I seem to have to deal with the remaining 20 percent.
> > Very nice idea.
>
> Still Peoplesoft,SAP and siebel might make a large market for a while yet.
> <g>.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
>
>
>
>
Received on Wed Jul 17 2002 - 04:03:32 CDT