Skip to Content
author's profile photo Former Member
Former Member

Performance Issues

Hii All,

I am facing a lot of performance issues in a report. It has been checked for all types of performance tuning methods. Used FOR ALL ENTRIES, used index also, sorted and deleted adjacent duplicates from driver table of for all entries, where condition also has fields in order as in table and i have used 'select <fields list> into table itab'...removing corresponding fields of....

i have also put fields list as declaredin internal table...i did all that....the problem is that the table selection which iam doing is BSIS and it has 18 crores of records in it....what more we can do to reduce the performance issues...to enhance the speed of execution? is there any advance performance tuning methods? please reply me...

thanks to all.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 03:59 PM

    hi Shakir,

    Check

    Performance tuning for Data Selection Statement

    http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

    Regards,

    Santosh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 04:01 PM

    Are you truly using one of the indexes of BSIS when selecting from it?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Also - have the DBAs run "stats" on the table and it's indexes. This will make sure that the indexes are "fresh" and up-to-date.

      When indexes are "stale"/aged, the Optimizer can actually ignore the indexes and go sequential when reading the table.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 04:02 PM

    If you're selecting based on document number, you're not using an index. We could help more if you post the code.

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member F.J. Brandelik

      F.J.,

      Your golden rule does not apply in the SAP system.

      The underlying DB engine (ie. Oracle Optimizer) will "re-write" your Open SQL statement into native SQL. It will structure the SQL in a way that achieves maximum performance... hence, no need to spend effort analyzing "restictive" and "order" properties of the tables/indexes.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.