4 Replies Latest reply on Jul 10, 2015 8:38 AM by Steven Hawkins

    How the select statement return the data when the statement has where condition in teiid VDB

    govindaraj s Novice

      Hi,

         

          Teiid VDB does not have any data, it contain only schema of the real DB, so when we query against VDB it fetch data from the real DB

       

          If we run select statement with where condition against the teiid VDB,

       

          1. Is it send the whole query to the real DB and fetch data for the query

       

          2. Or it fetch whole table and then do the where condition in the teiid side

       

          For example: select * from student where std_name like '%john%'

       

          1. is it return the students name which contain john text from the DB

       

          2. Or it return the whole students details from the DB and then do where condition in the teiid side

       

       

       

      Thanks & Regards

      Govindaraj s.