Database Toolbox

indexinfo

Get indices and statistics for database table

Syntax

• x = indexinfo(dbmeta, 'cata', 'sch', 'tab')
  

Description

x = indexinfo(dbmeta, 'cata', 'sch', 'tab') returns the indices and statistics for the table tab, in the schema sch, of the catalog cata, for the database whose database metadata object is dbmeta, where dbmeta was created using dmd.

Examples

Type

• x = indexinfo(dbmeta,'','SCOTT','DEPT')
  

MATLAB returns

• 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'
  

In this example:

• dbmeta is the database metadata object.
• orcl is the catalog cata.
• SCOTT is the schema sch.
• DEPT is the table tab.

The results contain two rows, meaning there are two index columns. The statistics for the first index column are shown in the following table.

Column	Description	Value
1	Catalog	orcl
2	Schema	SCOTT
3	Table	DEPT
4	Non-unique: 0 if index values can be non-unique, 1 otherwise	0
5	Index catalog	null
6	Index name	null
7	Index type	0
8	Column sequence number within index	0
9	Column name	null
10	Column sort sequence	null
11	Number of rows in the index table or number of unique values in the index	4
12	Number of pages used for the table or number of pages used for the current index	1
13	Filter condition	null

For more information about the index information, see
http://java.sun.com/products/jdk/1.2/docs/api/java/sql/package-summary.html for a description of the DatabaseMetaData object property getIndexInfo.

See Also
dmd, get, tables

importedkeys

insert