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.