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

[Steven Hawkins (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-5797:
----------------------------------
    Component/s: Query Engine


> 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
>          Components: Query Engine
>            Reporter: Christoph John
>            Assignee: Steven Hawkins
>            Priority: Major
>
> 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)