Help in ST05

[Former Member]

Hi All,

After displaying the SQL list from ST05, I can see more SQL statements in the list..

Can any one help me how to analysis the list furhter?

Thanks,

Priya

[Former Member]

Hi All,

After displaying the SQL list from ST05, I can see more SQL statements in the list..

Can any one help me how to analysis the list furhter?

Thanks,

Priya

[Former Member]

Hi,

In the trace list goto ->goto->display color legend, you will come to know how to analyse the list.

The SQL statements which are taking lot time will be shown in pink color.

Double click on the expensive select statement to see the code.

Create a secondary index if the selection is based on non primary keys.

Regards

Praveen

[Former Member]

If selection is based on non-primary keys, rather than blindly creating a secondary index, which may or may not be beneficial or harmful to OLTP, look for what it would take to revise the program to obtain and use the primary key for the Open SQL SELECT WHERE clause!

[Former Member]

Hi Priya,

Please check the following Blog. This is very helpful.

/people/siegfried.boes/blog/2007/09/05/the-sql-trace-st05-150-quick-and-easy

Happy Reading

Thanks

Nitesh

[Former Member]

>In the trace list goto ->goto->display color legend, you will come to know how to analyse the list.

>The SQL statements which are taking lot time will be shown in pink color.

No, this is not true, it is simply an execution which is above a limit, actually quite useless! You should not check the trace list at all.

Go to the summary by SQL statements, see sections 3 und 4 in my blog.

Come back to the trace list, when you are done with the summary.

Siegfried