Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_STATS, 4 of 41


SET_INDEX_STATS Procedure

This procedure sets index-related information.

Syntax

DBMS_STATS.SET_INDEX_STATS (
   ownname  VARCHAR2, 
   indname  VARCHAR2,
   partname VARCHAR2  DEFAULT NULL,
   stattab  VARCHAR2  DEFAULT NULL, 
   statid   VARCHAR2  DEFAULT NULL,
   numrows  NUMBER    DEFAULT NULL, 
   numlblks NUMBER    DEFAULT NULL,
   numdist  NUMBER    DEFAULT NULL, 
   avglblk  NUMBER    DEFAULT NULL,
   avgdblk  NUMBER    DEFAULT NULL, 
   clstfct  NUMBER    DEFAULT NULL,
   indlevel NUMBER    DEFAULT NULL, 
   flags    NUMBER    DEFAULT NULL,
   statown  VARCHAR2  DEFAULT NULL);

Parameters

Table 63-5 SET_INDEX_STATS Procedure Parameters
Parameter  Description 
ownname
 

Name of the schema. 

indname
 

Name of the index. 

partname
 

Name of the index partition in which to store the statistics. If the index is partitioned and if partname is NULL, then the statistics are stored at the global index level. 

stattab
 

User stat table identifier describing where to store the statistics. If stattab is NULL, then the statistics are stored directly in the dictionary. 

statid
 

Identifier (optional) to associate with these statistics within stattab (Only pertinent if stattab is not NULL). 

numrows
 

Number of rows in the index (partition). 

numlblks
 

Number of leaf blocks in the index (partition). 

numdist
 

Number of distinct keys in the index (partition). 

avglblk
 

Average integral number of leaf blocks in which each distinct key appears for this index (partition). If not provided, then this value is derived from numlblks and numdist

avgdblk
 

Average integral number of data blocks in the table pointed to by a distinct key for this index (partition). If not provided, then this value is derived from clstfct and numdist

clstfct
 

See clustering_factor column of the user_indexes view for a description. 

indlevel
 

Height of the index (partition). 

flags
 

For internal Oracle use (should be left as NULL). 

statown
 

Schema containing stattab (if different than ownname). 

Exceptions

ORA-20000: Object does not exist or insufficient privileges.

ORA-20001: Invalid input value.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback