Extra Indexes

Syntax: select-box for index type and table, text box to enter index name and fields

Extra Indexes may be created to improve search performance and accuracy in situations where the main text index (Index Fields) and/or its Compound Index Fields are not sufficient. They are not generally created unless suggested by Thunderstone tech support for certain queries.

Note that creating an Extra Index on a large-data profile may take several minutes or more. If the index Type is not Metamorph nor Metamorph Inverted, creating the index may also impede crawls or other database modifications. Non-Metamorph/Metamorph-Inverted indexes should therefore be created before the profile is crawled or populated with data to avoid this issue, if possible. Extra Indexes should only be created when the profile is not actively crawling, to minimize load and potential crawl impediments.