4 Replies Latest reply on Jun 24, 2015 9:02 AM by Ramesh Reddy

    Can I indexing the materialized view columns

    govindaraj s Novice

      Hi,

       

           I am quite new to Teiid VDB as well as Database Development, So I don't know this question is right or wrong  

       

           Often I am facing performance issue in my VDB

       

           Someone suggest me to index some columns in the table, but already I have materialized some tables in the VDB database, now can i indexing the materialized view columns

          

           If it is possible then can you please explain how can i indexing the materialized view columns in Teiid Designer,

       

           Currently I am using

       

           Teiid Designer 9.0

           Teiid Server 8.7

           JBoss EAP 6.1

       

       

      Thanks & Regards

      Govindaraj s.