Interested to Buy Any Domain ? << Click Here >> for more details...
HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
- 2 Answers
- 5163 Views
- I also Faced
- E-Mail Answers
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
How many universes can be created in a project?
What is package in BO
What sort of existing documents should business analysts refer to when starting on a new project?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
U r project in which stage in implementation?
What is difference between custom hierarchy and report based hierarchy?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is a bo repository?
What is the difference between user and versatile user?
What is the difference in creating filters in designer and business objects?
how to create metric universe ?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain when to use local filter and when to use global filter?
Explain what is the difference between business requirement document and use case document.
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...
