Subject | Re: [Firebird-Architect] Index tales - part 2 - Keyword FTS |
---|---|
Author | Jim Starkey |
Post date | 2006-10-09T11:47Z |
m_theologos wrote:
> 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' ...
>
>