How To Transfer Statistics To Different Schemas and Tables and Indexes and Partition and Columns
(Doc ID 2701368.1)
Last updated on SEPTEMBER 24, 2020
Oracle Database - Enterprise Edition - Version 18.104.22.168.0 and later Information in this document applies to any platform.
The purpose of this document is to explain how to copy statistics among different schemas, tables, indexes, partition and columns by DBMS_STATS package. It can be used to copy statistics from one table or index to another one with the similar data volumn and distribution to avoid unnecessary statistics gathering.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!