Statistics on Partitioned Tables

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 –

Part 1 – Default options – GLOBAL AND PARTITION

Part 2 – Estimated Global Stats

Part 3 – Stats Aggregation Problems I

Part 4 – Stats Aggregation Problems II

Part 5 – Minimal Stats Aggregation

Part 6a – COPY_TABLE_STATS – Intro

Part 6b – COPY_TABLE_STATS – Mistakes

Part 6c – COPY_TABLE_STATS – Bugs and Patches

Part 6d – COPY_TABLE_STATS – A Light-bulb Moment

Chandra Rawat 09 June 2023

A Guide to INSERT, UPDATE, and DELETE Statements in Oracle

Oracle

In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, UPDATE, and DELETE. These commands are used to insert new data into tables, update existing data, and delete data from tables, respectively. In this article I will take a closer look at each of these statements and how … Read more

Oracle

Statistics on Partitioned Tables

Subscribe for more articles

Rate this article

Doug Burns

Related articles

A Guide to INSERT, UPDATE, and DELETE Statements in Oracle