Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

if we run a report it is taking so much time to display the
report,what to do to increase th performance of the report

Answer Posted / srikanth

Remove unnecessary objects and variables if any.make sure
you remove alerters if any unless it is the
requirement.Take the report query and run in Database.See
how much time its taking.From report query check whether
in 'where' clause columns have indexes.If not discuss with
oracle admin and add indexes.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain in detail about type 2(scd),

1108


What is the difference in creating filters in designer and business objects?

1031


Explain what is the difference between business requirement document and use case document.

1031


What is aggregate table and aggregate fact table ... Any examples of both?

1072


What sort of existing documents should business analysts refer to when starting on a new project?

1011


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?

2233


What is the functional & architectural differences between business objects and web intelligence reports?

2422


How to execute the plsql procedure from the report by clicking with mouse?

1138


How we drill up week to month?

1082


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1838


How many universes can be created in a project?

1057


Explain when to use local filter and when to use global filter?

1366


How to generate the report from excel sheet?

1189


What is the difference between datawarehousing and businessintelligence?

1109


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1043