Oracle Associate / Disassociate Statistics Version 19.3
Morgan's Library Page Header
For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
Data Dictionary Objects
Use the ASSOCIATE STATISTICS statement to associate a statistics type (or default statistics) containing functions relevant to statistics collection,
selectivity, or cost with one or more columns, standalone functions, packages, types, domain indexes, or indextypes.
For a listing of all current statistics type associations, query the USER_ASSOCIATIONS data dictionary view.
If you analyze the object with which you are associating statistics, then you can also query the associations in the USER_USTATS view.
Create Column Association
ASSOCIATE STATISTICS WITH COLUMNS <schema.table.column>
[WITH <SYSTEM | USER> MANAGED STORAGE TABLES];