Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Are BIP for Oracle SCM Cloud optimized?

Received Response
61
Views
4
Comments

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

Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 3 - Community Apprentice

    Can someone please comment/respond?

  • Rank 6 - Analytics Lead

    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

  • Rank 6 - Analytics Lead

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

    Mark

    1.0.0.20
  • Rank 3 - Community Apprentice

    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

Welcome!

It looks like you're new here. Sign in or register to get started.