DB type

Determines whether the field is an index or filter field, or that Content Manager OnDemand does not create a column in the application group database table for the field.

Index

The field uniquely identifies a document or the field is typically used for most queries. Indexes provide fast and direct database access. However, indexes require more storage to hold than filters and take longer to create and maintain.

Filter

The field is not used to identify a document or the field is always used with an index field to refine a query. Filters require a sequential search of the database.

Not in Database

A field that contains the same value for every document in the input data (for example, a date field). Content Manager OnDemand maintains the value in the segment table that points to the index records. Content Manager OnDemand does not create a field in the application group table and does not store the index value in the rows that are added to the database. Note: Date fields are almost always defined as filters, not indexes.