Appropriate Content: Informix Documentation Team
96QY_Pat_Smith 27000196QY Tags:  informix database index update_statistics ustlow_sample statistics_low 11.70 1,818 Views
If you upgrade to IBM Informix Version 11.70xC4, you can generate index statistics based on sampling when you run UPDATE STATISTICS statements in LOW mode. For an index with more than 100 K leaf pages, the gathering of statistics using sampling can increase the speed of the update statistics operation.
To enable sampling, set the USTLOW_SAMPLE configuration parameter or the USTLOW_SAMPLE option of the SET ENVIRONMENT statement. For example, to enable sampling for the current session, specify:
SET ENVIRONMENT USTLOW_SAMPLE '1';
For more information, see USTLOW_SAMPLE configuration parameter or USTLOW_SAMPLE environment option.
For information about other new Version 11.70 features, see What's new in Informix.
IngeHalilovic 060000MPB8 Tags:  thesaurus database index informix analyzer stopword search text 1,616 Views
In IBM Informix 11.70.xC2, you have many more option for customizing basic text searching for your needs.
See the What's New for links to each of these features.
Here are a couple of examples:
The following example creates a bts index on two XML fields and uses a different analyzer for each field:
CREATE INDEX boats_bts
The following example creates stopword list of am, be, and are for all fields except the fields author and title, which have their own stopwords, and the field edition, which does not have any stopwords.
CREATE INDEX books_bts ON books(book_data bts_lvarchar_ops)