Manually Setting Column Statistics: Example Using SET_COLUMN_STATS to Set LOW_VALUE and HIGH_VALUE of a Column Manually (Doc ID 1276174.1)

Last updated on APRIL 20, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Information in this document applies to any platform.

Goal

In some cases, it may be necessary to set some column statistics manually in order to allow the optimizer to make correct plan decisions.

For example, some circumstances we might want to do this could be:


Since the procedure to set LOW_VALUE and HIGH_VALUE is quite long, this example explains how to set LOW_VALUE and HIGH_VALUE of a column manually for data types NUMBER, CHAR, DATE.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms