Performance Tunning in report

10-11  Source: Network gathering  Views:0 

Advertisement
Dear All,
we have one report. if i run the report then it will take 2 to 4 hrs.
I have checked main query & formula columns, all the query reading the index.
How can i Tune this report & how can reduce the running time.
Pls help me.
Wrong forum, betters ask in the SQL-forum.
Apart from that: have a look at the explain-plan and check the cost of your select-statement. If you are using the cost-based optimizer and have a very low cost for the statement but the time it takes to complete is very high, you may have to regather the table statistics. Wrong or old table statistics can create problems for even higly optimized select-statements.
Regards
Markus
Related articles
  • Performance Tunning - Oracle Reports 6i 11-30

    Hi Gurus, I have an Oracle Apps Reports 6i with a formula column having so much of conditions making the reports to take long time to get completed. Its taking 20 mins to complete. Please your help on this. Thanks, GenooHi what is your database versi

  • Performance Tunning in report 10-11

    Dear All, we have one report. if i run the report then it will take 2 to 4 hrs. I have checked main query & formula columns, all the query reading the index. How can i Tune this report & how can reduce the running time. Pls help me.Wrong forum, be

  • Performance tunning in exraction. 10-11

    hii frnds,    can anyone plz tell me the performance tunning in extraction,in report,in dataloading.plz reply me in pointwise.. Thanks Rosy Please search for available information before posting. Edited by: kishan P on Jan 24, 2012 10:57 AMHi Rosy, P

  • Performance tunning 10-11

    Dear Experts, I am urgently looking forward to some comprehensive documentation on Performance tunning elaborating on the issues like:- 1.)In what instances should we do performance tunning.... 2.) why it is neccessary and 3.) what r the <b><u>

  • How to do Performance tunning in OBIEE 11-30

    Hi All, We are using OBIEE 10.3.4 version on windows envorinment .In our OBIEE project we are using 9 reports my requriment is we need to do performance tunning for OBIEE side.For eace report accessing its taking around 80 sec.We need to decrease the

  • Performance issue in Report (getting time out error) 10-11

    Hi experts, I am doing Performance for a Report (getting time out error) Please see the code below and . while looping internal table IVBAP after 25 minutes its showing  time out error at this poit -> SELECT MAX( ERDAT ) . please send alternate code

  • Performance of a Report Based On VirtualProvider 10-11

    Dear BW experts, We have created a new BEx 3.x report, which contains about 6 queries, and 2 pre queries. The report runs very slowly, the upload time is about 40 seconds. The report itself contains one tab with 11 tables. The MultiProvider that the

  • How to improve the query performance in to report level and designer level 10-11

    How to improve the query performance in to report level and designer level......? Plz let me know the detail view......first its all based on the design of the database, universe and the report. at the universe Level, you have to check your Contexts

  • Low Performance in the report with cell defition 10-11

    Hi all, In one of our queries (3.5), we had to use lots of cell definition. And after execution of the report, it stays in "Formatting Result Area" and "Retrieving Result from BW Server" for a very long time (about 30 minutes). There i

  • Performance issue in report programming.. 10-11

    Hi, I am using one customized Function Module  whithin a loop of internal table containing fields of PROJ table for about 200 records . And in  the source code of function module there is set of select queries for different tables like COSS COSP , AU

  • Performance issue of report 10-11

    Hi Friends, Can you please give me the exact answer for the below question. Suppose my report program is taking long time to execute, what are the reasons that may effect the report. and what are the remedies should i follow, please provide appropria

  • Performance Issue Crystal Report and Oracle 10-11

    Hello, We have one procedure that takes 3 input parameters and returns Cursor from Procedure that is used to design the report. There is no caluculation involved here and cursor is opended dynamically. We are using Oracle Native connection. When we c

  • Performance issue webi report-BOXI3.1 10-11

    Hi, We have a requirement for a report where we will give user a set of objects (26 u2013 31) to do analysis using interactive viewing feature. Here we are facing severe performance issues and memory issues as the data that we are calling is huge( ar

  • How to optimize the performance of crystal report? 10-11

    Hi, -I have to design a crystal report with best possible optimization. Optimization is main concern since report will run against 1-2 million data set. Though I am using parameter to fetch only the required data, required data can go till 1 million

  • Performance tunning in oracle 10-11

    Hi friends, I am himansu, i am facing a problem during performance tunning of query in oracle , please guide me how to tune a query which will give better performance.907977 wrote: Hi friends, I am himansu, i am facing a problem during performance tu

  • Performance analysis of report or transaction 10-11

    Hello Experts, How do we analyse the performance of a report or a transacton in SAP. I want to know thetransactions and the steps that needs to be followed in order to get this. points are guaranteed... thanks sankarhi, SE30 - gives you a run time an

  • PERFORMANCE of this REPORT object 10-11

    Hi Experts I have a REPORT object, having a few SELECT Queries in it. I need to analyze the PERFORMANCE of this REPORT object. How can I analyze the performance of a SELECT Query alone in it - that is time taken to execute this SELECT Query alone? Ho

  • How to increase the performance of a report 10-11

    can any body tell me how to increase the performance of a report?//// i have prepared a report to show the expense detail .I have used BSIS and BSAS table. But whenever I am executing it is facing runtime error (TIME_OUT error ). Moderator Message: D

  • Regarding performance of a report 10-11

    Hi friends, In the loop statement I am using modify statement for updating the data in the internal table . I have to improve the performance of a report. is there any alternative for Improving teh performance., Regards, JayanHI If u r modifying Ztab

  • Regarding Performance tunning... 10-11

    HI Experts, can you suggest me, how exactly performance is checked. what is the measure we considered for performance check. what are ideals status of the performance check for a certain program. that is, how much should be database use, abap use and