I am doing some performance test and I am noticing a big difference between the OBIEE report and the SQL statement generated by it. When I run the SQL statement generated by the report in SQL Developer or TOAD it takes 13 seconds however the same SQL Statement in OBIEE takes 1 minute !
Thanks for your reply. However, I do not understand what you mean. Could you be more specific ?
To answer your questions, yes, I have the query from the nqquery.log, yes, I run it on SQL Developer and yes I found a big difference between the query running on SQL Developer and the same query running on OBIEE. So my question is why ? As it is the same query running on the same database ?
I did not run the SQL query as a direct database request from OBIEE but this is an excellent idea and I will do it.
Yes, I run the physical in TOAD / SQL Developer and I guess OBIEE only runs the logical query. I have only one calculation on my report (I have to calculate the number of lines returned by the report) Not sure if this could explain the difference.
The cache is enabled and the logging level is set to 0 for the user.