LOCALINDEXATOMS System Table Description

Description

A pseudo table generated for internal debugging purposes only. This table does not provide much information for users. It contains information about all NuoDB atoms used in indexes, and in particular information about their encoding.

Client applications should never contain code that accesses SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.

Fields

Field Type Description

INDEXNAME

string

The name of the index

SCHEMA

string

The schema in which the index was created

TABLENAME

string

The table name on which the index exists

INDEXIDENTIFIER

string

The internal index identifier of the index

OBJECTID

bigint

The ID for the database object

CATALOGID

bigint

The catalog ID for the database object

ENCODING

string

An internal string representing the encoding used for this index.

CODE

integer

A value which maps to the index type.

ENCODINGTYPE

string

LOSSLESS or LOSSY

FLAGS

integer

Bitmask where:

  • 1 = always auto generated

TYPE

integer

Index type:

  • 0 = Primary Key

  • 1 = Unique Index

  • 2 = Secondary Index

STRUCTURE

string

The internal data structure type of the index

LEAFHISTOGRAMS

integer

The number of leaf histograms

Indexes

None