Just a helpful SAP note for slow SQL statements

[Former Member]

Hi Guys,

Just wanted to share this SAP note with you. I am sure many of you might have gone through it.

[SAP Note 155413 - Analysis of slow SQL statements|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=155413]

Cheers,

Abu

[Former Member]

Hi Guys,

Just wanted to share this SAP note with you. I am sure many of you might have gone through it.

[SAP Note 155413 - Analysis of slow SQL statements|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=155413]

Cheers,

Abu

[Former Member]

.... it was not updated since 2002 ... so very restricted in usefulness

Please read my blog on the SQL Trace, I know it is short, but it contains a lot of things.

Read section 3 and 4, the display in section 3 was not available in 2002, it is much more powerful

than the normal tracelist. If you read section 3 and 4 carefully then you will be able to find most

performance issuses on the db.

The way to remove them is not explained there, it will be explained somewhere else, unfortunately not in six pages

Siegfried

[Former Member]

>

> Hi Guys,
> 
> Just wanted to share this SAP note with you. I am sure many of you might have gone through it. 
> 
> [SAP Note 155413 - Analysis of slow SQL statements|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=155413]
> 
> Cheers,
> Abu

Hi,

I would bet not as many as you might think - many questions here suffering form not GOING through

the analysis before they post it here.

Meantime I think questions to SQL statement performance here will only be answered when the execution plan on the statement is posted with it.

bye

yk

[HermannGahm]

Hi YukonKid,

Execution Plan AND... statement, variables, indexes, statistics... and the ST05 runtime figures THAT would be nice if that would be posted with the sql statements... sigh.

Kind regards,

Hermann

[Former Member]

> Meantime I think questions to SQL statement performance here will only be answered when the

> execution plan on the statement is posted with it.

but you know the execution plan of a Z-table is useless ...

Very often I would be happy if only the relevant line of the summary would be provided, many people have no performance problem, they read just too much ... or they mix up disk times with time from cache.

Siegfried

[Former Member]

>

> 
> Very often I would be happy if only the relevant line of the summary would be provided, many people have no performance problem, they read just too much ... or they mix up disk times with time from cache.
> 
> Siegfried

Hi Siegfried,

wich complies to my 1st rule of SQL access : The fastest way to do something, is not doing it at all...

bye

yk