CREATE INDEX ... WITH options Syntax - Caveat

In Texis version 7, many index options that were previously only alterable via global SQL properties may be specified directly in the SQL CREATE INDEX statement, e.g. index expressions:

CREATE METAMORPH INVERTED INDEX searchIndex
    ON myTable(Title\Meta\Body,Price)
    WITH WORDEXPRESSIONS ('\alnum{2,99}', '[\x80-\xFF]{2,99}')
      KEEPNOISE 'on' INDEXMETER 'on';

This helps reduce side-effects that can occur when a global setting was changed to create one index but erroneously left on for another: the setting can now be moved into the creation statement itself. Search the online Texis manual for "Index Options" for details.