ALL_ASSOCIATIONS

All associations available to the user

Columns
   ___________________________
 
   OBJECT_OWNER
      Owner of the object for which the association is being defined
   OBJECT_NAME
      Object name for which the association is being defined
   COLUMN_NAME
      Column name in the object for which the association is being defined
   OBJECT_TYPE
      Schema type of the object - column,type,package or function
   STATSTYPE_SCHEMA
      Owner of the statistics type
   STATSTYPE_NAME
      Name of Statistics type which contains the cost,selectivity or stats funcs
   DEF_SELECTIVITY
      Default Selectivity if any of the object
   DEF_CPU_COST
      Default CPU cost if any of the object
   DEF_IO_COST
      Default I/O cost if any of the object
   DEF_NET_COST
      Default Networking cost if any of the object
   INTERFACE_VERSION
      Version number of Statistics type interface implemented


© Copyright SS64.com 1999-2014
Some rights reserved