{"id":73295,"date":"2012-08-01T17:10:02","date_gmt":"2012-08-01T17:10:02","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/uncategorized\/statistics-on-partitioned-tables\/"},"modified":"2021-07-14T13:07:53","modified_gmt":"2021-07-14T13:07:53","slug":"statistics-on-partitioned-tables","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/statistics-on-partitioned-tables\/","title":{"rendered":"Statistics on Partitioned Tables"},"content":{"rendered":"

When Jonathan Lewis decided it was time to post a list of the Partition Stats posts<\/a> on his blog and Noons suggested I made them easier to track down<\/a>, I listened. So this post will link to the others and, at least in the short term, I’ve also included links in the side-bar on my Oracle blog<\/a>.<\/p>\n

Part 1<\/a> – Default options – GLOBAL AND PARTITION<\/p>\n

Part 2<\/a> – Estimated Global Stats<\/p>\n

Part 3<\/a> – Stats Aggregation Problems I<\/p>\n

Part 4<\/a> – Stats Aggregation Problems II<\/p>\n

Part 5<\/a> – Minimal Stats Aggregation<\/p>\n

Part 6a<\/a> – COPY_TABLE_STATS – Intro<\/p>\n

Part 6b<\/a> – COPY_TABLE_STATS – Mistakes<\/p>\n

Part 6c<\/a> – COPY_TABLE_STATS – Bugs and Patches<\/p>\n

Part 6d<\/a> – COPY_TABLE_STATS – A Light-bulb Moment<\/p>\n","protected":false},"excerpt":{"rendered":"

When Jonathan Lewis decided it was time to post a list of the Partition Stats posts on his blog and Noons suggested I made them easier to track down, I listened. So this post will link to the others and, at least in the short term, I’ve also included links in the side-bar on my Oracle blog. Part 1 &#8211…<\/p>\n","protected":false},"author":55246,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143533],"tags":[],"coauthors":[],"class_list":["post-73295","post","type-post","status-publish","format-standard","hentry","category-oracle-databases"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/55246"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=73295"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73295\/revisions"}],"predecessor-version":[{"id":91749,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73295\/revisions\/91749"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=73295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=73295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=73295"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=73295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}