Author: shawkins Date: 2010-08-11 16:07:58 -0400 (Wed, 11 Aug 2010) New Revision: 2446 Modified: trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml Log: TEIID-168 updating hint syntax Modified: trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml =================================================================== --- trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2010-08-11 20:05:44 UTC (rev 2445) +++ trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2010-08-11 20:07:58 UTC (rev 2446) @@ -562,7 +562,7 @@ </section> <section id="cache_hint"> <title>Cache Hint</title> - <para>Non-update user commands may be preceded with a cache hint, e.g. /* cache */ select ..., to inform the engine that the results of command should be cached. The scope of the result, either session or global, will be deteremined automatically from the determinism level of the source queries and functions executed.</para> + <para>Non-update user commands may be preceded with a cache hint, e.g. /*+ cache */ select ..., to inform the engine that the results of command should be cached. The scope of the result, either session or global, will be deteremined automatically from the determinism level of the source queries and functions executed.</para> <para>ResultSet caching must be enabled for this hint to have an effect.</para> </section> <section id="procedural_relational"> @@ -759,7 +759,7 @@ <listitem><para>FROM <link linkend="nested_table">TABLE(subquery)</link> [AS] alias</para></listitem> <listitem><para>FROM table1 JOIN table2 MAKEDEP ON join-criteria</para></listitem> <listitem><para>FROM table1 JOIN table2 MAKENOTDEP ON join-criteria</para></listitem> - <listitem><para>FROM table1 left outer join <link linkend="optional_join">/* optional */</link> table2 ON join-criteria</para></listitem> + <listitem><para>FROM table1 left outer join <link linkend="optional_join">/*+ optional */</link> table2 ON join-criteria</para></listitem> <listitem><para>FROM <link linkend="texttable">TEXTTABLE...</link></para></listitem> <listitem><para>FROM <link linkend="xmltable">XMLTABLE...</link></para></listitem> </itemizedlist>