topic Re: REPORT in Application Development and Automation Discussions

REPORT

Former Member — Tue, 31 Jul 2007 16:04:04 GMT

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

execution. What steps will i do to reduce the

execution time?

Re: REPORT

Former Member — Thu, 02 Aug 2007 11:57:14 GMT

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.

Re: REPORT

former_member188827 — Thu, 02 Aug 2007 11:58:41 GMT

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

Re: REPORT

Former Member — Thu, 02 Aug 2007 11:59:12 GMT

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.

Re: REPORT

Former Member — Thu, 02 Aug 2007 12:00:29 GMT

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>