Manually Setting Column Statistics: Example Using SET_COLUMN_STATS to Set LOW_VALUE and HIGH_VALUE of a Column Manually
Last updated on APRIL 20, 2015
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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:
- when it takes too long to gather all the statistics for a big table
- when we want to help the optimizer to choose a specific execution plan based on some specific statistics
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.
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