how often to analyze partition table [message #628715] |
Thu, 27 November 2014 05:58 |
|
rahul1982
Messages: 53 Registered: November 2011 Location: Pune
|
Member |
|
|
Hi,
I'am having partition table in Oracle (11g) database and we are populating data into that table on daily basis.
This partition table is used in join condition with other tables but SQL takes time to extract the data. But when i have analyzed the partition table, SQL query has populated result within few seconds.
Pls. advice if we are populating data in to partition table very often, do we need to analyze that table daily ?
Thank you.
|
|
|
|
Re: how often to analyze partition table [message #628730 is a reply to message #628724] |
Thu, 27 November 2014 08:29 |
Roachcoach
Messages: 1576 Registered: May 2010 Location: UK
|
Senior Member |
|
|
If you're joining "todays" partition, stats wont help you much because the data most likely wont exist at the time of gather. Many shops get around this by copying stats over from the last partition. Be careful around dates etc and test this thoroughly, but it's the most common fix I've come across.
Theoretically dynamic sampling may work too, I have not tested that however.
[Updated on: Thu, 27 November 2014 08:30] Report message to a moderator
|
|
|
|