08-22-2018 4:44 PM
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
08-22-2018 6: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
Depends on which tables it has retrieved data is dangerous creating/activating database view.
Let us know the results.
Regards
08-22-2018 6: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.
08-22-2018 6: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
Depends on which tables it has retrieved data is dangerous creating/activating database view.
Let us know the results.
Regards
08-22-2018 6:48 PM
08-23-2018 2:13 PM
Jennifer,
If you post the code, you will be able to get more accurate replies.
You can explore, OPEN CURSOR/FETCH CURSOR/CLOSE CURSOR.
K.Kiran.
08-23-2018 2:24 PM
Hi Jennifer,
on which DB is your system running?
Kind regards,
Martin