Guidelines for adding text search index elements to a standard table

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.