Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
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
Answers
-
Can someone please comment/respond?
0 -
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
0 -
Also ..... BIP has an 'Explain Plan' button on the data modeller, so you'll be able to see the plan.....
Mark
0 -
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
0