Oracle Associate / Disassociate Statistics Version 18.104.22.168
Morgan's Library Page Header
For how many years have you been working
with physical servers? Software Defined Servers can improve performance and
security while lowering complexity and cost. With Software Defined Servers
you define servers with an optimum configuration to your environment rather
than being memory starved and cpu over-provisioned. Find out how you can
improve your computing environment with
TidalScale. your friends.
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];