Home » RDBMS Server » Performance Tuning » Statistics on Empty Partition (oracle 10.2.0.3 in HP-UX11)
Statistics on Empty Partition [message #411238] Thu, 02 July 2009 12:18 Go to next message
d_ponnilavan
Messages: 13
Registered: May 2005
Location: india
Junior Member
Hi,
I've a table partitioned on processed month. We create partitions for one yr & each month one partition gets the data.
Each partition holds ~ 8M record
We gather stats on all the partitions every Sunday even though some of the parts are empty. By now Jan-July2009 will have data & Sep-Dec2009 will be empty. But still we gather stats...
Will there be any perf issue because we gather stats on empty partition? One of my team members is saying so but couldn't explain the reason.
Could you guys clarify it?

Thanks in advance
Ponns
Re: Statistics on Empty Partition [message #411240 is a reply to message #411238] Thu, 02 July 2009 12:34 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Will there be any perf issue because we gather stats on empty partition?

No, it is benefit then Oracle knows they are empty.

Regards
Michel

[Updated on: Thu, 02 July 2009 12:35]

Report message to a moderator

Previous Topic: Index on normal and random column data
Next Topic: query_rewrite_enabled
Goto Forum:
  


Current Time: Sat Dec 10 18:53:32 CST 2016

Total time taken to generate the page: 0.07728 seconds