Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

Appendix

Operating Limits

Environment Catalog

ASK Indexes

MDK Indexes

Composite Indexes

 

Appendix

 

Environment Catalog Limits

  • Databases per Environment -- No Limit
  • Tables per Environment -- 4095
  • Columns per Table -- 1023
  • Native Indexes per Environment -- No Limit
  • Maximum Record Length -- 64 Kbytes
  • If there is a C STRING column at the end of the record, the maximum length is 128 Kbytes - 64 Kbytes for the final C STRING and 64 Kbytes for the rest of the record.
  • Maximum Character Field Size -- 4095 Bytes
  • Maximum Field Size for C STRING -- 64 Kbytes

 

 

ASK Index Limits

Each sorted index uses one index file

  • Indexes per Environment -- 255
  • The number of keys is limited by the 255 index files per Environment.
  • Indexes per Table -- 255
  • The number of keys is limited by the 255 index files per Environment.
  • Maximum Key Length -- 250 bytes
  • The maximum key length includes the length of the internal identifier (unique key length for parent tables, 4 bytes for child tables.
  • Composite Key Components per Index -- 250

 

MDK Index Limits

  • Indexes per Environment -- No limit
  • Indexes per Domain -- No limit
  • Indexes per Table -- No limit
  • Domains per Environment -- 255
    Each domain uses one index file if it uses a 32-bit native key as the internal identifier (Omnidex ID). Otherwise, each domain requires two of the 255 available index files.
  • Groups per Domain -- 200
  • Maximum Length of Indexed Keyword -- 32 Bytes
    This limit typically affects only Zoned columns, or Character and C STRING columns indexed with the No Parse options. Because these columns' values are treated as one keyword, if they are longer than 32 bytes, only the first 32 bytes are indexed.
  • Composite Index Length -- 255 Bytes
  • Components per Composite Index -- 250
  • External File Size Limit -- 64 Kbytes
  • Records per Domain -- 2,147,483,647
  • Parents per Child -- 31
    Except as further restricted by the underlying database.
  • Children per Parent -- 31
    Except as further restricted by the underlying database.

 

Composite Index Limits

  • Maximum Index Length
    255 bytes
    250 bytes, including the unique key (parent); 4 bytes (child)
  • Maximum Index Components
    255
    250
  • Maximum Composite Indexes
    No Limit
    255 less the number of index files required by the domains.

Omnidex imposes a limit of 255 index files. Each domain uses one index file if it uses a 32-bit native key as the internal identifier (OMNIDEX ID). Otherwise, each domain requires two of the 255 available index files.

 

Top