User`s guide

indexinfo
7-163
indexinfo
Return indices and statistics for database tables
Syntax
x = indexinfo(dbmeta, 'cata', 'sch', 'tab')
Description
x = indexinfo(dbmeta, 'cata', 'sch', 'tab') returns indices and statistics for
the table tab, in the schema sch, of the catalog cata, for the database whose database
metadata object is dbmeta.
Examples
Get index and statistics information for the table DEPT in the schema SCOTT of the
catalog orcl, for dbmeta.
x = indexinfo(dbmeta,'','SCOTT','DEPT')
x =
Columns 1 through 8
'orcl' 'SCOTT' 'DEPT' '0' 'null' 'null' '0' '0'
'orcl' 'SCOTT' 'DEPT' '0' 'null' 'PK_DEPT' '1' '1'
Columns 9 through 13
'null' 'null' '4' '1' 'null'
'DEPTNO' 'null' '4' '1' 'null'
The results contain two rows, meaning there are two index columns. The statistics for the
first index column appear in the following table.
Column Description Value
1 Catalog orcl
2 Schema SCOTT
3 Table DEPT