indexinfo (Database Toolbox)

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

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/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html for a description of the getIndexInfo property.

See Also
dmd, get, tables

importedkeys insert