RE: ANALYZE question

From: Ratnesh Kumar Singh <ratnesh.singh_at_patni.com>
Date: Wed, 24 Jul 2002 02:03:21 -0800
Message-ID: <F001.004A0871.20020724020321@fatcity.com>

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 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 table?

---

Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ratnesh Kumar Singh
  INET: ratnesh.singh_at_patni.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jul 24 2002 - 05:03:21 CDT