Example view to see why partitions are marked stale.
If the stale reason is 'HIST', then this implies there is new column usage information and instructs gather stats to check whether a new histogram is required.
Content-Length: 237123 | pFad | http://github.com/RanjanHub/oracle-db-examples/tree/main/optimizer/stale_reason
98Name | Name | Last commit date | ||
---|---|---|---|---|
parent directory.. | ||||
Example view to see why partitions are marked stale.
If the stale reason is 'HIST', then this implies there is new column usage information and instructs gather stats to check whether a new histogram is required.