Oracle Transactional Business Intelligence

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

OTBI Analysis Pivot vs Table View Performance

Question
1
Views
0
Comments

Good Day Experts,

Is there a difference in terms with the report performance when using Pivot view vs Table view in OTBI analysis?
Is Table view faster to load than Pivot view?

I have a report for GL and SLA and we have 25M+ of data and we usually encounter report slowness to load.
I am currently using a Pivot view.
Just want to confirm if there are any differences before changing to Table view.

Thank you.