text: With Multiple Loads per Database Table enabled, the system uses the maximum number of 
  rows to determine when to close a table. A segment likely contains the data from more than 
  one input file. If the Maximum Rows setting is too large, the segment is not expired until all of 
  the documents in the table reach their expiration dates. If the Maximum Rows setting is too 
  small, segments are created constantly and potentially deleted (based on the expiration 
  date). This large number of tables imposes a performance impact during the search query 
  time and expiration time. 
  
  The system derives the expiration date from the Segment field (or the date that the data was 
  loaded, if there is no Segment field) and the Life of Data and Indexes field. If the Segment 
  field contains a date in the*MMYY*format, data is eligible to be deleted on the first day of the 
  month (*MM*). 
  
  To specify the Segment field, complete the following steps: 
  
  1. Click the**Field Information**tab. 
  2. Select a date or date and time field. 
  3. Select the**Segment**check box. 
  
  **Expiration type: Document**
  When the expiration type is set to Document, the system deletes a document from the 
  application group. To determine when to delete a document, the system uses the value of the 
  Expire Date field and the Life of Data and Indexes field. If the Expire Date field contains only 
  the month and year (*MMYY*format), the system deletes documents on the first day of the 
  month (*MM*). 