HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
Answer Posted / manoj
Derived Tables decrease the performance because even if you
include one single object from this table the entire query
from the table is executed .
You can see this in the sql Query panel.
hence i would avoid using any derived tables unless
mandatory
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain difference between zabo and webi?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is difference between webi and infoview?
What three things do you consider to be the most important factors for a manager?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What is top business?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
is it possible to export the webi reports to crystal reports?with out using businessview?
How we drill up week to month?
Difference between b.o 5.1 and 6.1b?
How to open a universe with out using the Designer ??
Did you face any problems while creating reports? Name? Solutions?
Explain which versions are used in the bo dashboard work?
What would you consider as your biggest achievement and why?