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
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
How were the reports scheduled and how to resolve unexecuted documents?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
what will be the contents for a functional requirements specifications
What is Indexing? how did u implement indexing?
What is the difference in creating filters in designer and business objects?
what are the tables used in health care domain project and columns used in report?
Can more than 1 metric be applied on an analytic in business objects?
Explain the data types present in bo and what happens if we implement view in the designer and report?
What are the steps to do to use alerts in bo?
how to prepare the documentation in business objects and where to get the requirement?
U r project in which stage in implementation?
Explain what are the steps to do to use alerts in bo?