topic performance affect due to sequential access in Application Development and Automation Discussions

performance affect due to sequential access

Former Member — Thu, 11 Jan 2007 06:23:16 GMT

Hi,

We are facing a performance problem in our system. we are running program with select statement with proper indexing followed but still it is showing as a sequential read in SM50. This is happening for SAP std programs also.

Database statistics are also updated last week.Why still it is showing as a sequential read. Most of the large tables shows sequential read only. whether it can relate to memory or any other issues.

Regards,

Karthik.k

Re: performance affect due to sequential access

christian_wohlfahrt — Thu, 11 Jan 2007 07:46:08 GMT

HI Karthik!

SM50 is not a proper tool for analyzing select statements. Either only primary key, maybe also an access with unique secondary index will be displayed as direct access, the rest is counted as sequential - even if good secondary indices are used.

Make a SQL-trace (ST05) to check the access. Here you can see, which index (sometimes even with no. of index fields) is used. If this looks OK, don't worry about SM50. If you have bad accesses, check the source code and the actual filling of the select fields - even if all fields are programmed, not all are filled in a program all the time.

Regards,

Christian

Re: performance affect due to sequential access

alex_m — Thu, 11 Jan 2007 11:30:42 GMT

Use ST05 for SQL performance trace.