INDEXFIELDS System Table Description

Description

Information about the fields in all the indexes on persistent tables in the database.

Fields

Field Type Description
INDEXNAME string Name of the index (this may be NuoDB-generated)
SCHEMA string Schema containing the table containing the field on which this index exists.
TABLENAME string Table containing the field on which this index exists.
FIELD string Name of field on which this index exists.
POSITION integer Position of this field in the definition of the index.
PARTIAL integer Not used.
RECORDS_PER_VALUE integer Not used.

Indexes

Primary Index: INDEXFIELDS..PRIMARY_KEY on fields: SCHEMA, TABLENAME, INDEXNAME, FIELD
Secondary Index: INDEXFIELDS_TABLE on fields: SCHEMA, TABLENAME

Example

Using the same Example as above for SYSTEM.INDEXES (INDEXES System Table Description), we see one entry for the HOCKEY..PRIMARY_KEY and three entries, one for each field, for the PLAYER_IDX index.

SELECT * FROM system.indexfields WHERE tablename='HOCKEY';

     INDEXNAME       SCHEMA  TABLENAME  FIELD  POSITION  PARTIAL  RECORDS_PER_VALUE 
 ------------------- ------- ---------- ------ --------- -------- ------------------
 HOCKEY..PRIMARY_KEY HOCKEY  HOCKEY     ID        0       <null>       <null> 
 PLAYER_IDX          HOCKEY  HOCKEY     NUMBER    0       <null>       <null> 
 PLAYER_IDX          HOCKEY  HOCKEY     NAME      1       <null>       <null> 
 PLAYER_IDX          HOCKEY  HOCKEY     TEAM      2       <null>       <null>