Full-Text Indexing
Topic Last Modified: 2006-06-12
By implementing full-text indexing, you can do fast full-text searches by using the CONTAINS Predicate and the FREETEXT Predicate in a Structured Query Language (SQL) query. The full-text indexing process indexes words in message and document bodies and additionally indexes words within message properties of the urn:schemas:mailheader: Namespace. Full-Text indexing also enables Microsoft® Outlook® users to search for documents as well as messages. Non-binary attachments are also indexed.
To implement full-text indexing, use the Microsoft Exchange System manager to navigate to the store to be indexed. Right-click the store and click Create Full-Text Index. After you create the index, you can specify options on the Full-Text Indexing tab of the store's Properties to set the update interval, type of population, and other settings. For more information about using full-text indexing, see Exchange System Manager help.
Full-text indexing creates indexes on words in the bodies of the following document types: .doc, .xls, .ppt, .html, .htm, .asp, .txt, and .eml.
Full-text indexing creates search catalogs for use by the search engine; however, there is no programmatic way to manipulate search catalogs in the Exchange store.
The properties that participate in full-text indexing are listed in the following table. The first parameter of the CONTAINS Predicate and the FREETEXT Predicate allows you to include searching the content in one or all of these properties in addition to searching the message or document body.
| MAPI Properties | urn:schemas:httpmail: Namespace properties |
|---|---|
PR_SUBJECT, PR_SUBJECT_W |
|
PR_BODY, PR_BODY_W |
|
PR_SENDER_NAME, PR_SENDER_NAME_W |
|
PR_SENT_REPRESENTING_NAME, PR_SENT_REPRESENTING_NAME_W |
|
PR_DISPLAY_TO, PR_DISPLAY_TO_W |
|
PR_DISPLAY_CC, PR_DISPLAY_CC_W |
|
PR_DISPLAY_BCC, PR_DISPLAY_BCC_W |
|
PR_SENDER_EMAIL_ADDRESS, PR_SENDER_EMAIL_ADDRESS_W |