Subject Re: [Firebird-Architect] Index tales - part 2 - Keyword FTS
Author Jim Starkey
m_theologos wrote:
> Hi,
>
> 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' ...
>
>
Text search needs to be multi-table and multi-field to be useful.