Calls
-
PROCEDURE DBMS_STATS.PREPARE_COLUMN_VALUES[_NVARCHAR | _ROWID](srecIN OUT STATREC,valuesINvalues_type[,rwminIN ROWID,rwmaxIN ROWID]);[,rwminIN ROWID,rwmaxIN ROWID]); STATREC is a record type with the following structure:
(epc NUMBER, minval RAW(2000), maxval RAW(2000), bkvals NUMARRAY, novals NUMARRAY)
srec holds the number of values in values in the epc column of the record and the number of occurences of each of the values in bkvals. values can support values_types of CHARARRAY, DATEARRAY, NUMARRAY, or RAWARRAY for the corresponding value types. For PREPARE_COLUMNS_NVARCHAR, use the first set of rw parameters. For PREPARE_COLUMNS_ROWID, use the second set of rw parameters.
-
PROCEDURE DBMS_STATS.SET_COLUMN_STATS(ownnameIN VARCHAR2,tabnameIN VARCHAR2,colnameIN VARCHAR2,partnameIN VARCHAR2 DEFAULT NULL,stattabIN VARCHAR2 DEFAULT NULL,statidIN VARCHAR2 DEFAULT NULL,distcntIN NUMBER DEFAULT NULL,densityIN NUMBER DEFAULT NULL,nullcntIN NUMBER DEFAULT NULL,srecIN STATREC DEFAULT NULL,avgclenIN NUMBER DEFAULT NULL,[flagsIN NUMBER DEFAULT NULL,]statownIN VARCHAR2 DEFAULT NULL[,no_invalidateIN BOOLEAN DEFAULT FALSE]#); This version is used for standard statistics. Sets statistics for ownname.tabname.colname in partition partname in statown.stattab with optional identifier statid. (If stattab is NULL, statistics are stored in the dictionary.) Sets the density, number of nulls (nullcnt), and average length for column (avgclen). If no_invalidate ...