How can we improve performance?

Answer Posted / tilak

1)usinf aggregated tables
2)using shortcut joins
3)removing unwanted classes and objects
4)removing unwanted joins
5)lov should be based on smaller look up tables

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

685


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

579


How we drill up week to month?

619


What is report template in b.o?

588


U r project in which stage in implementation?

1950






Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

553


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

602


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....

1491


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1537


What are the join problems comes appart from loop,chasm & fan Traps

1556


What three things do you consider to be the most important factors for a manager?

602


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

935


Explain when we use aggregate awareness function in designer?

590


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

606


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2607