|
OBJECT_OWNER
|
VARCHAR2(30)
|
NOT NULL
|
Owner of the object for which the association is being defined
|
|
OBJECT_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Name of the object for which the association is being defined
|
|
COLUMN_NAME
|
VARCHAR2(30)
|
|
Column name in the object for which the association is being defined
|
|
OBJECT_TYPE
|
VARCHAR2(9)
|
|
Kind of object with which statistics are being associated: column, type, package or function, indextype, or domain index.
|
|
STATSTYPE_SCHEMA
|
VARCHAR2(30)
|
|
Owner of the statistics type
|
|
STATSTYPE_NAME
|
VARCHAR2(30)
|
|
Name of statistics type that contains the cost, selectivity or statistics functions
|
|
DEF_SELECTIVITY
|
NUMBER
|
|
Default selectivity of the object, if any
|
|
DEF_CPU_COST
|
NUMBER
|
|
Default CPU cost of the object, if any
|
|
DEF_IO_COST
|
NUMBER
|
|
Default I/O cost of the object, if any
|
|
DEF_NET_COST
|
NUMBER
|
|
Default networking cost of the object, if any
|
|
INTERFACE_VERSION
|
NUMBER
|
|
Identifies the version number of the ODCIStats interface. Value is 1 for statistics type implementing Oracle8i 8.1; 0 for types implementing Oracle9i 9.0.0.
|
