Last updated on MAY 23, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 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 (and there are several different types: table, column (with or without a histogram), and index). it can be difficult to locate optimizer statistics information across all the various data dictionary views.
When dealing with a partitioned table it is also important to understand what type of physical segments are created and what other types are merely logical in nature (the segment actually consumes physical space on disk).
- When you create a partitioned table, there is no table segment created on disk - only partition segments are created. The table is simply a logical concept.
- When you create a composite-partitioned table, no table segment or partition segments exist - only subpartition segments. Again, the table and partition layers are logical concepts and do not consume any space on disk.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms