Are BIP for Oracle SCM Cloud optimized?

Shalindra Singh

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

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

Mark_Daynes

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

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