|Subject||Re: [Firebird-Architect] Index tales - part 2 - Keyword FTS|
> Hi,Text search needs to be multi-table and multi-field to be useful.
> Studying a little the FB indexes and some issuses about when the
> indexes are 'good' or 'bad' I have some small ideeas to put in your
> attention. (I broke this thema in more independent messages).
> 1. Keywords
> Defining a structure like:
> CREATE KEYWORD INDEX IDX1 ON T1(TextField1) SEPARATORS '
> .,!@#$%^&*()' MIN_LETTERS 2 BANNED_WORDS 'AND', 'OR', 'THE' ...