When adding text search index elements to standard tables, keep
the following considerations in mind:
- You can add the text search element only to non-transactional
tables.
- The searches performed for the text search indices are case insensitive.
- You can define more than one text search indices per entity.
- You cannot define multiple columns on a text index.
- IBM® supports
CTXCAT and CONTEXT text search index types on Oracle.
- Defining both the extended entity and the text search index in
the same extension XML file is recommended.