Skip to Content

something better than join table

Hallo Abapers,

I have a programme to call the data from three tables and make segregation in some fields.
this has been developed on the join statement basis.

This program is taking sooooo much time now until we can see the result tabel (if we can). as we are talking here about millions of records !!!!

Do you have some Ideas or other methods that are better and effecter than join tables to achieve this???

Best Regards

Jenie

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Aug 22, 2018 at 05:27 PM

    Hi Jennifer,

    First of all, I suggest you consider analyzing that program issue before changing it.

    Following some steps to analyses program performance.

    1. SE30 or SAT (Runtime Analysis) transaction

    2. ST05 - SQL Trace (Performance Trace) transaction

    Attached excellent documentation about SQL Trace

    https://wiki.scn.sap.com/wiki/display/SAPSQL/How+to+run+transaction+st05+to+trace+a+program%2C+transaction+or+user+execution

    Depends on which tables it has retrieved data is dangerous creating/activating database view.

    Let us know the results.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 22, 2018 at 05:00 PM

    When you say "millions of records" do you mean in the tables or in the results? If the SELECT statement is fetching millions of rows, it will certainly take a lot of time no matter which method you use.

    A join itself cannot be bad for performance regardless of how many rows exist in joined tables, provided the join conditions are used correctly and the WHERE clause is using the correct indexes.

    If it is not against your company policies, post the entire SELECT statement here and someone can offer some help.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2018 at 01:24 PM

    Hi Jennifer,

    on which DB is your system running?

    Kind regards,
    Martin

    Add a comment
    10|10000 characters needed characters exceeded

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.