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
- 5071 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
Explain is data mart?
Is there any other repository domains rather than universe, security, document?
What three things do you consider to be the most important factors for a manager?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Which command using Query Analyzer will give you the version of SQL server and operating system ?
can anybody tell me about complicated object you have created
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Explain what are the steps to do to use alerts in bo?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain is there any default username & pwd for bo designer & supervisor?
Explain in detail about type 2(scd),
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How were the reports scheduled and how to resolve unexecuted documents?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
