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 on solaris.

Thank you very much.


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

Original text of this message