Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Shalindra Singh
    Are BIP for Oracle SCM Cloud optimized?
    Topic posted September 26, 2018 by Shalindra SinghBlue Ribbon: 750+ Points, last edited September 11, 2019, tagged Reporting 
    46 Views, 4 Comments
    Title:
    Are BIP for Oracle SCM Cloud optimized?
    Summary:
    If Reports are called with input parameters, will those column be indexed for better performance
    Content:

    Hi,

    If I create custom Data Model and Report on BI Publisher and provide input parameters like startDate and endDate where StartDate and EndDate will apply in Last Modified Date of a certain table. Will Last Modified Date column be indexed for better performance? 

    How to get information on which column as input parameter will give better performance in the large data table and which will not? This is important for me to know before I start creating BI publisher report to extract data out from Oracle SCM cloud for analytical purpose.

    Thanks

    Shalindra Singh

    Version:
    11.1.1.7

    Comment

     

    • Shalindra Singh

      Can someone please comment/respond?

      • Mark daynes

        Hi Shalindra,

        You must know the table you are applying the restriction to and the guides show the indexes on them, so checking out your table and indexes - which are detailed at the end of the section on the table defintion - should answer 'Will Last Modified Date column be indexed for better performance?'.

        Regards,

        Mark

        • Shalindra Singh

          Thanks Mark,

          If I take Example of DOO_HEADERS_ALL table, and as per below link, I do not see last_update_date as indexed field. Does this mean that it is not recommended to make use of  last_update_date in the filter criteria while creating model.

          https://docs.oracle.com/cloud/r13_update17c/scmcs_gs/OEDSC/DOO_HEADERS_ALL_tbl.htm

      • Mark daynes

        Also ..... BIP has an 'Explain Plan' button on the data modeller, so you'll be able to see the plan.....

        Mark