My Oracle Support Banner

How to Locate the Optimizer Statistics for a Partitioned Table or Index (Doc ID 2080521.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


This document explains how to locate optimizer statistics for a partitioned table or index within the data dictionary.

Since a given data dictionary view only contains information on one type of statistic, it can be difficult to locate optimizer statistics information across all the various data dictionary views.  The cost-based optimizer, as input, uses statistics on tables, (sub)partitions, columns, and indices.

When dealing with a partitioned table, it is also important to understand what type of physical segments are created (i.e., the segment actually consumes physical space on disk), and what other types are merely logical in nature.

Please be aware that optimizer statistics stored within the data dictionary on partitioned tables will include some rows which represent a segment, and others which represent only a logical entity.  However, the fact that the stats do not represent a space-consuming item does not make them any less valuable to the cost-based optimizer.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Single-Level Partitioned Table
 Column Groups
 Composite-Partitioned Table

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.