update stats on partitioned tables

From: <Mayen.Shah_at_lazard.com>
Date: Thu, 2 Apr 2009 15:51:58 -0400
Message-ID: <OF81199392.83FA2CF9-ON8525758C.006C8C72-8525758C.006D210F_at_lazard.com>

Hello Everyone,

Can some one please guide me to document/links for best practice for updating stats for partitioned tables and indexes? We have an application where data gets loaded on monthly basis. Typically after each load we update full stats on all tables in which data gets loaded. This takes long time. We are thinking of updating stats only for partitions in which data have been loaded. Is this better method? If we collect stats on one or two partitions, how does global stats gets updated?

Version 10.2.0.4 on solaris.

Thank you very much.

Mayen

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 02 2009 - 14:51:58 CDT

This message: [ Message body ]
Next message: Tanel Poder: "RE: Less bytes when transferring table"
Previous message: Adric Norris: "CDC plus declarative transformation to delete XML column?"
Next in thread: Greg Rahn: "Re: update stats on partitioned tables"
Reply: Greg Rahn: "Re: update stats on partitioned tables"
Reply: Arul Ramachandran: "Re: update stats on partitioned tables"
Maybe reply: Randolf Geist: "Re: update stats on partitioned tables"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message