topic Re: something better than join table in Application Development and Automation Discussions

something better than join table

Former Member — Wed, 22 Aug 2018 15:44:29 GMT

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

Re: something better than join table

P14397410 — Wed, 22 Aug 2018 17:00:34 GMT

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.

Re: something better than join table

roberto_forti — Wed, 22 Aug 2018 17:27:54 GMT

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

Re: something better than join table

ChrisSolomon — Wed, 22 Aug 2018 17:48:43 GMT

You mean a "view" (ie vision?) ?

Re: something better than join table

kiran_k8 — Thu, 23 Aug 2018 13:13:19 GMT

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.

Re: something better than join table

Former Member — Thu, 23 Aug 2018 13:24:45 GMT

Hi Jennifer,

on which DB is your system running?

Kind regards,
Martin