O'Reilly logo

Oracle in a Nutshell by David C. Kreines, Rick Greenwald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Calls

PROCEDURE DBMS_STATS.PREPARE_COLUMN_VALUES[_NVARCHAR | _ROWID] (srec IN OUT STATREC, values IN values_type [,rwmin IN ROWID, rwmax IN ROWID]); [,rwmin IN ROWID, rwmax IN 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 (ownname IN VARCHAR2, tabname IN VARCHAR2, colname IN VARCHAR2, partname IN VARCHAR2 DEFAULT NULL, stattab IN VARCHAR2 DEFAULT NULL, statid IN VARCHAR2 DEFAULT NULL, distcnt IN NUMBER DEFAULT NULL, density IN NUMBER DEFAULT NULL, nullcnt IN NUMBER DEFAULT NULL, srec IN STATREC DEFAULT NULL, avgclen IN NUMBER DEFAULT NULL, [flags IN NUMBER DEFAULT NULL,] statown IN VARCHAR2 DEFAULT NULL [, no_invalidate IN 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required