Skip to Content
author's profile photo Former Member
Former Member

performance affect due to sequential access


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.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 11, 2007 at 07:46 AM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.