| Statistics on Empty Partition [message #411238] |
Thu, 02 July 2009 12:18  |
d_ponnilavan
Messages: 12
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  |
Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| 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]
|
|
|
] 
Members
Search
Help
Register
Login
Home
