JBoss Community Archive (Read Only)

Teiid 8.12


The OPTION keyword denotes options the user can pass in with the command. These options are Teiid specific and not covered by any SQL specification.


OPTION option (, option)*

Supported options:


All tables specified in the OPTION clause should be fully qualified, however the name may match either an alias name or the fully qualified name.

The makedep and makeind hints can take optional arguments to control the dependent join. The extended hint form is:

MAKEDEP tbl([max:val] [[no] join])

Previous versions of Teiid accepted the PLANONLY, DEBUG, and SHOWPLAN option arguments. These are no longer accepted in the OPTION clause. Please see the Client Developers Guide for replacements to those options.

MAKEDEP and MAKENOTDEP hints may take table names in the form of @view1.view2...table. For example with an inline view "select * from (select * from tbl1, tbl2 where tbl1.c1 = tbl2.c2) as v1 option makedep @v1.tbl1" the hint will now be understood as applying under the v1 view.

JBoss.org Content Archive (Read Only), exported from JBoss Community Documentation Editor at 2020-03-13 12:26:06 UTC, last content change 2015-07-14 13:51:27 UTC.