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 advice
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
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: digest
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
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
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: Multiple
: RE: ANALYZE question
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
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 supported
: ANALYZE question
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
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 message.
If the text doesn't display correctly, save the attachment to disk, and then
open
]
-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: Multiple recipients
]
-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: Multiple recipients of list
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
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
14 matches
Mail list logo