[teiid-issues] [JBoss JIRA] (TEIID-5797) Please add FULLTEXT indexes and efficient fulltext search to materialized tables

[Christoph John (Jira)]

Christoph John created TEIID-5797:
-------------------------------------

             Summary: Please add FULLTEXT indexes and efficient fulltext search to materialized tables 
                 Key: TEIID-5797
                 URL: https://issues.jboss.org/browse/TEIID-5797
             Project: Teiid
          Issue Type: Feature Request
            Reporter: Christoph John
            Assignee: Steven Hawkins


Hello,
this feature request is to enhance performance in case of materialized table usage. The idea is to offload database workload to several Teiid instances using materialized tables for serving text search requests. It would be great to have an efficient index-based fulltext search feature available on them. Similar to the MATCH AGAINST functionality and FULLTEXT indexes on a mysql database. Hence indexing and matching against single words in one or multiple database columns.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)