Try OpenEdge Now
SQL Development
OpenEdge SQL Data Manipulation Language
:
Using indexes
:
Index system catalog tables
Index system catalog tables
The following SQL system catalog tables contain information concerning indexes:
SYSINDEXES
is a core system table. Each row in the table represents one component of each
INDEX
in the database.
SYSIDXSTAT
provides information on each index in the database.
For more information on the SQL system tables, see
OpenEdge Data Management: SQL Reference
.
SYSINDEXES is a core system table. Each row in the table represents one component of each INDEX in the database.
SYSIDXSTAT provides information on each index in the database.