Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Adding a HINT to the Select Statement

    Posted 09/14/20 09:43 AM

    ​Hello,

    If I have a long running cognos report and the DBA adds a HINT ( /*+ NO_QUERY_TRANSFORMATION */ ) to the select statement on the database view, what does this actually do or how does it change the cognos processing of the report?


    Thanks,
    Jen



    ------------------------------
    Jenifer Broughton
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Adding a HINT to the Select Statement

    Posted 09/15/20 10:22 AM

    Looks like you are using Oracle.  Look at this link and search for your hint. https://docs.oracle.com/cd/B19306_01/server.102/b14211/hintsref.htm#i27644

     

    I'm curious.  Is this report run on demand by a user or by a schedule?

     

    Jerome P Roberts

    IT Specialist

    Philips Oral Healthcare - Los Angeles

    jerome.roberts@philips.com

    Description: <a href=image002.jpg@01CF4423.BA6A3360">

     


    The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.





  • 3.  RE: Adding a HINT to the Select Statement

    Posted 09/18/20 08:37 AM

    https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/Comments.html#GUID-D316D545-89E2-4D54-977F-FC97815CD62E

    If an in-database view or hand-written (native/passthru) SQL statement embedded in a model/report etc, it is invisible to query engine.

    So side effects (+ or -ve) of hint depends on how your system deals with in ORACLE.



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------



  • 4.  RE: Adding a HINT to the Select Statement

    Posted 09/21/20 07:14 AM
    Edited by System Admin 01/20/23 04:38 PM
    Thank you both for this information.  The report is being run via the schedule, but when changes are made we may run it adhoc.​
    I converted the view to SQL and added the hint and the report runs much faster.



    ------------------------------
    Jenifer Broughton
    ------------------------------

    Original Message


  • 5.  RE: Adding a HINT to the Select Statement

    Posted 09/21/20 11:32 AM

    I ask because if adding the hint changed the data query to native sql, then some end users may not be able to run the report on demand.

     

    Jerome P Roberts

    IT Specialist

    Philips Oral Healthcare - Los Angeles

    jerome.roberts@philips.com

    Description: <a href=image002.jpg@01CF4423.BA6A3360">

     


    The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.



    Original Message


Related Content