REPORT

[Former Member]

We are running a report. It is taking long time for

execution. What steps will i do to reduce the

execution time?

[Former Member]

Hi,

I think u must have used many tables with inner jion, that's why it is taking more time.

So, split the query,

for example first retrieve fields from a single or two tables.

Likewise extract fields from different tables separately, and finally join using loop with common key fields within the tables. Then the report will run faster.

Regards,

Sathya Rajkumar.

[former_member188827]

u can use trace st05 to find out which statements are taking longer duration 2 exxecute and resolve accordingly.

[Former Member]

HI,

Most Common Bottlenecks

• Accessing a table without using index.

• Retrieving data from a table when the data is already known.

• Retrieving excess data.

• Nested SELECT'S or LOOP'S.

• Inefficient internal table usage.

• Accessing Cluster and Pool tables.

• Extended data locking (causing serialization and potentially deadlocks).

• The use of “OR”, ”NOT” and “IN” in a SELECT statement.

• Bypassing table buffering.

[Former Member]

Hi Raj,

I think you used Join Condition.

Just copy paste your select statement alone in

forum.

So we can suggest you.

<b>Regards,

Jackie.</b>