4 Replies Latest reply on May 6, 2013 11:12 AM by Ramesh Reddy

    How to use Access Patterns to define Dependent Joins?

    Sanjeev Gour Novice

      Hi-

       

      The Teiid docs mention this-

       

      The conditions when a dependent join is used are determined by the query planner based on Access Patterns, hints, and costing information.

       

      I understand that we can use query hint and the option clause to direct the query planner to use the dependent joins.

       

      If I understand it correctly, I can also define an Access Pattern that Teiid can use and generate a query plan with dependent joins. With the available documention or maybe I am not able to locate it, it is not clear how I can define Access Patterns. Is there any example that I can refer? Do I need to define it in the Teiid metadata, if so, how?

       

      Any help is much appreciated.