• Info
• Initial State
• View Source
• Run

XML Examples

XS-S-8 Freetext indexing hooks

Building a freetext index using a custom PL indexing hooks

Freetext Index

• The freetext index has a default mechanism for indexing and unindexing.
• By default indexing/unindexing is performed over data column.
• A custom PL hook can be made for indexing/unindexing, and be associated to the freetext index definition.
• The data from additional columns can be indexed in the custom PL hooks.
• Working together with off-band data columns to make index sensitive to changes in the additional columns data they should be declared as off-band data.

Example

The example SQL script does the following steps:

• Definition of the hooks
• Making of text index