Thanks all for your advice. Will check an option to do estimate.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, July 24, 2002 7:23 PM
> At the last Open World I attended a couple of sessions
> where the general adv
At the last Open World I attended a couple of sessions
where the general advice for 9i DB is to use ANALYZE
ESTIMATE without specifying ANY value. A few brief
"comparision" tests did show that it got better results
than the alternatives tested.
As always, YMMV & HTH
HAND!
--
Please see the offi
t;
>
> >
> > Please correct me if my assumption is wrong, we had strange behaviour
here
> > when SYS objects were analyzed on a development db.
> >
> > Regards,
> > Patrice Boivin
> > Systems Analyst (Oracle Certified DBA)
> >
> > System
technologiques
> > Informatics Branch | Direction de l'informatique
> > Maritimes Region, DFO | Région des Maritimes, MPO
> >
> > E-Mail: [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Sent: Wednesday, July 24, 2002 9:09 A
ge-
> Sent: Wednesday, July 24, 2002 10:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ANALYZE question
>
> This message uses a character set that is not supported by the Internet
> Service. To view the original message content, open the attached messa
Maritimes, MPO
> >
> > E-Mail: [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Sent: Wednesday, July 24, 2002 9:09 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: ANALYZE question
> >
> > DBMS_STATS can be used to
ormatique
Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 24, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: ANALYZE question
This message uses a character set that is not support
> Sent: Wednesday, July 24, 2002 9:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ANALYZE question
>
> DBMS_STATS can be used to analyze tables.
>
> Dave
>
> -Original Message-
> Sent: Wednesday, July 24, 2002 4:03 AM
> To: Multiple
O
E-Mail: [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 24, 2002 9:09 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ANALYZE question
DBMS_STATS can be used to analyze tables.
Dave
-Original Message-
Sent: Wednesday, July 24, 2002 4:03 AM
To:
DBMS_STATS can be used to analyze tables.
Dave
-Original Message-
Sent: Wednesday, July 24, 2002 4:03 AM
To: Multiple recipients of list ORACLE-L
Apart from explicity running an ANALYZE command against a table, what, if
any, other events/actions can cause an analyze to be run on the ta
No Impact. Analyze would just collect the latest statistics for the
concerned table and the next time any query gets fired on this table the
optimizer (CBO) would generate the execution plan based on these statistics.
I also believe that this would be healthier sign as the CBO is generating
plan
dbms_stats
--- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote:
> Apart from explicity running an ANALYZE command against a table,
> what, if
> any, other events/actions can cause an analyze to be run on the
> table?
>
> -
> Seán O' Neill
> Organon (Ireland) Ltd.
> [subscribed
An export has default parameter of STATISTICS=ESTIMATE.
If such an exported file is imported , the default import
parameter ANALYZE=Y will result in the import utility
executing the analyze stmts in dump file.
-Original Message-
Sean
Sent: Wednesday, July 24, 2002 2:33 PM
To: Multiple r
Apart from explicity running an ANALYZE command against a table, what, if
any, other events/actions can cause an analyze to be run on the table?
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]
--
Jared,
Thanks for replying.
You are right about binds and histograms. I didn't mean to imply "real"
histograms, where the number of buckets (size) are specified. Instead, in
this case, a simple "analyze table foo compute statistics" was used. This
would result in "column statistics" for *all* co
Larry,
You might want to give this a try using PL/SQL and bind variables.
I don't know if this has changed in 8i, but in 8.x, queries using
bind variables could not make use of histograms ( column statistics )
Jared
On Sat, 3 Feb 2001, larry elkins wrote:
> Sam,
>
> You had the right topic.
They most definitely non indexed will have influence on the CBO - there is
the ANALYZE FOR ALL COLUMNS option anyhow, that is there for that reason. I
think also likely used in conjunction with histograms on fields - DSS / Data
Warehouse :
Regards
Sam
-Original Message-
Sent: Saturday,
Sam,
You had the right topic. The original questions was "In what way do
statistics (or lack thereof) on non-indexed columns influence the CBO?". I
was having trouble thinking of a scenario where this would make a
difference, hence my posing the question to the list.
I finally thought of a scena
I missed out on original e-mail regarding this subject so I hope I'm on the
right track, but I assume that the CBO will use non-indexed columns in its
algorithms. I know DB2 would use non-indexed columns, maybe because DB2 is
a more advanced optimizer(only because IBM have been doing it a lot lon
Steve,
Thanks for taking the time to reply.
My initial thought was that the stats would be of no use, but, the thing
that still makes me wonder is why would a simple "analyze table compute
statistics" gather statistics on *all* columns. For this to be the default
behavior, there could be a reaso
Hi Larry,
I think that the answer is that the statistics are of no use to the CBO until an
index is created.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 2 February 2001 11:16
To: Multiple recipients of l
Listers,
7.3.4.3 database on HP-UX 11.0.
In what way do statistics (or lack thereof) on non-indexed columns influence
the CBO?
I've searched high and wide for any info on this and came up with nothing,
and, I can't think of a reason or example off the top of my head. And no,
this isn't an OCP,
22 matches
Mail list logo
