Subject RE: [firebird-support] Index question
Author Alex Taylor
Hi guys!

Thank for your answers! The final solutionis the following: I wrote 2
UDF: WORDCOUNT AND WEXTRACTWORD. They are placed in the required table's
AfterInsert,AfterUpdate, and AfterDeelete trigger. There are a separate
table, called WORDS. This contains the PK to the original table and the
extracted words in separate records of course. Both 2 columns are
indexed as well. When doing a text search, I search the WORDS table with
STARTING WITH using the index and then JOIN the original table to it. It
is lightning fast!!!!

Once again, many thanx!!!

Best regards:Alex :-)