Segment table

When you load data into an application group, Content Manager OnDemand adds a row of index data to an existing database table or creates a new database table, depending on the database organization of the application group. For a Single Load per Database Table application group, Content Manager OnDemand creates a new table of index data each time you load data into the application group. For a Multiple Loads per Database Table application group, Content Manager OnDemand adds records to an existing table each time you load data into the application group.

However, in order to better manage index data and provide consistent query performance, Content Manager OnDemand limits the size of a database table to approximately 10 million rows. When a table reaches this limit, Content Manager OnDemand automatically closes the table, creates a new database table, and begins adding records to the new table.

Content Manager OnDemand maintains a segment table that contains one row for each table of application group data. The row contains fields that identify the application group table, the earliest date found in any row in the segment, and the latest date found in any row in the segment.

When a user runs a query, Content Manager OnDemand first searches the segment table to identify the application group table(s) that might contain documents that match the query. Content Manager OnDemand searches only the tables that fall within the date range specified by the user, regardless of the number of tables of application group data.