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



          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.