OBIEE 11g: Can We Generate OBIEE Physical SQL Without Having Sub Query?
Last updated on MAY 22, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.151020 and later
Information in this document applies to any platform.
Can we generate OBIEE physical SQL without having sub Query?
In nqquery.log, Physical Query always has sub-query as bellow:
(select distinct T43769.ENAME as c1
from EMP T43769 ) D1
order by c2
Checking SQL trace, you can verify that the SQL was executed with sub Query on database.
Simple Query that customer expected to change is as following:
select distinct 0, T43769.ENAME as c1 from EMP T43769;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms