RE: DELETE STATISTICS

From: <ramakrishna.gv_at_db.com>
Date: Wed, 23 Aug 2000 07:35:22 +0530
Message-Id: <10597.115310@fatcity.com>

Hi

with ANALYZE table|index DELETE STATISTICS

     The following tables will be affected
          user_tables              V8 & V7
          user_tab_columns         V8 & V7
          user_tab_col_statistics        V8 only
          where table_name=<table_name>

 Thanks & Regards

---

 Ram

• Message History ----------------------------------------

From: tswilley_at_agency.com on 22/08/2000 21:12 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: RE: DELETE STATISTICS

Did this question ever get answered?

-----Original Message-----

Mengler
Sent: Friday, August 18, 2000 12:36 PM
To: Multiple recipients of list ORACLE-L

For V7.3.4 what TABLE.ROWs are affected by ANALYZE table|index DELETE STATISTICS For V8.1.* what TABLE.ROWs are affected by ANALYZE table|index DELETE STATISTICS I assume that certain columns get set to NULL by "DELETE STATISTICS". Which ones?

--

Charlie Mengler          Maintenance Warehouse
charliem_at_mwh.com         10641 Scripps Summit Ct
858-831-2229             San Diego, CA 92131

Ready, Fire, Aim; is a sure way to fail as a DBA!
--

Author: Charlie Mengler
  INET: charliem_at_mwh.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).

--

Author: Tamara Swilley
  INET: tswilley_at_agency.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 Received on Tue Aug 22 2000 - 21:05:22 CDT