Home > Default > Can we change physical SQL generated by BI Server?

Can we change physical SQL generated by BI Server?

November 30Hits:0
Advertisement
Hello gurus:
I have a doubt. How can we change the physical SQL generated by OBIEE?
is there any way we can modify the SQL Cost?
Let me know.
Thanks.
Vinay R.

Answers

So If I have a View and a physical table, so View will have lower cost compared to Table?
Can you explain a bit more about this?There is absolutely no way we can estimate the cost of a view or a table we don't know. There are too many variables so your question is too wide and unprecise. Generally speaking views that select from only one table do not add any extra cost to the execution plan, Oracle will convert them to the underlaying table. Having said the usual reason to have a view is to join different tables and apply some data filtering conditions so it will depend a lot on what kind of query you are running.

Read other 8 answers

Tags:

Related Articles

  • Can we change physical SQL generated by BI Server?November 30

    Hello gurus: I have a doubt. How can we change the physical SQL generated by OBIEE? is there any way we can modify the SQL Cost? Let me know. Thanks. Vinay R.So If I have a View and a physical table, so View will have lower cost compared to Table? Ca

  • View log not showing physical SQL generated in OBIEE 11.1.1.6.7October 11

    Hi, I am currently using OBIEE 11.1.1.6.7 version. In this version I am unable to view the physical SQL generated by OBIEE under Administration --> Manage Marketing Jobs --> Select a Job --> Click on View SQL OR Administration --> Manage Sessi

  • [NQQuery log]: Physical SQL generated agaisnt 2 Database in OBIEE 11gNovember 30

    Hi Experts, I have a problem regarding the physical SQL generated by Query log. So this is the setup. SCENARIO 1: Oracle Data Warehouse DB - col1 - col2 - col3 OLAP_OBIEE - col4 When I run these columns together in Analysis. It seems like the physica

  • Logical SQL to physical SQL in datamodel.October 11

    I am designing a report in BI publisher and for that I am creating a datamodel. My datamodel contains 4 dataset with 4 different logical SQLs and all use source as Oracle BIEE. When I generate/execute xml from datamodel I observed in nqquery.log that

  • Logical SQL to physical SQL taking time in datamodel.October 11

    I am designing a report in BI publisher and for that I am creating a datamodel. My datamodel contains 4 dataset with 4 different logical SQLs and all use source as Oracle BIEE. When I generate/execute xml from datamodel I observed in nqquery.log that

  • Multiple Physical SQL for one reportNovember 30

    Hi, Can someone please explain me why i am seeing multiple physical Queries generated for a single report. Please find below the physical sql. select sum(T314772.MONTHLY_BUDGET_AMT) as c1, T157680.NAME as c2 from W_PARTY_D T157680, XXKC_CUSTSITE_SHIP

  • Row Number() over partition by Order by in OBIEE Physical SQLNovember 30

    Hi , I created a OBIEE report in Dev using Answers. When I move the same report to Live, the count of rows was more in Live environment when compared to Dev. The objects count is same in both Dev and Production. WheniI verified the log file, I found

  • How to get physical SQL queryOctober 11

    Hi All, How to get the physical SQL query for the OBIEE reports. Thanks in advance, Haree.Hi Anitha, Thanks for your reply, I am getting XML script in log file. (Settings > Administration > Manage Sessions > View Log). How to get physical SQL que

  • Difference between logical and physical SQLOctober 11

    Hi all, I created a dashboard prompt and added some columns from the dimensions and one column from the fact table. When I run the report in the dashboard and filters using the prompts,I see in the logical sql that all the filters have been applied t

  • OBIEE:  logical SQL to Physical sql conversionOctober 11

    Hi, Is there any way i can get the physical sql from logical sql ( Apart from reading log file).. I am looking something like JAVA api which does that for us.. Do we have any mapping table which stores this mapping. Does the OBIEE provides any Java A

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 1.501 s.