One
option that does not take advantage of any fancy indexing methods is to create a
trigger on the table, on insert/update/delete, which extracts each individual
word from the field you care about, and creates an entry in another 'keyword'
table, id = 'word', value = pk of your original table. then index the
keyword table on the 'keyword' field, and do your searches from there.
this should improve performance substantially, even on very large return sets,
because the keyword table rows are very small and thus a lot of them fit in a
disk block.
-
Jeremy
|
Title: Message