Chapter 3. Administration 51
A thorough understanding of the way that users search for documents in the system is 
required before you determine the fields that will be indexes and the fields that will be filters. 
Only fields that will be heavily used when users are searching for and retrieving documents 
need a type of index. An index field will always be included in a folder query.
Segment 
Segment is the date or date and time field that is used to limit the number of tables that are 
searched during a folder query. By using a segment date to limit folder queries to a single 
table or a limited set of tables, performance is improved. The segment date is especially 
important for application groups that contain a large amount of data. 
If the expiration type is segment, Content Manager OnDemand also uses the segment field to 
determine when to delete data from the application group. Y ou might specify only one 
segment field for each application group.
Application ID field
The application ID field is used to identify an application within an application group when you 
create an application group that contains more than one application. The database mapping 
fields are used to map the value to be stored in the database as the label that is displayed for 
folder queries and in the subsequent query hit list. A query can be made against a specific 
application in an application group or against all of the applications in an application group.
3.1.3  Applications
An application defines the data to index and load. An application associates the data with an 
application group and specifies the type of indexing process to perform on the data. It also 
defines any logical views to be put in place for users and determines any special print options 
to use with the data. In this section, we consider several of the load information attributes that 
are defined for an application.
Load Information tab
The Load Information tab specifies the processing and resource information that the Content 
Manager OnDemand loader uses to load the input data onto storage volumes and to load the 
associated index data into the database. 
Important: Folder queries that use filter fields alone result in a sequential scan through 
database tables. An index field must always be included in folder queries. For more 
information about folders, see 3.1.4, “Folders” on page 54.
Note: Date fields are almost always defined as filters, not indexes.
Note: The date field that is used for the segment date must always have a type of filter. By 
default, an index is created for the segment date, and setting the segment date to a type of 
index creates unnecessary processing.