2 Replies Latest reply: Jun 13, 2013 6:41 AM by Wayne Fortuin RSS

    Oracle SQL Select Statement with "Hint"

    Tim Benoit

      If I code an Oracle SQL select statement in my loadscript and I include an Oracle "hint" - does anyone know if QlikView passes the hint along to the database as part of the sql query? The reason I'm asking is that when I view the code in the loadscript editor the hint part of the statement is colored like a comment and I'm concerned that comments in the loadscript code don't get passed to the database.

       

      For example, the "hint" part of the syntax in the following statement is the /*+PARALLEL*/ text:

      SELECT /*+PARALLEL*/ NAME, BALANCE FROM BIGTABLE;

       

      Thanks