Please give me explaination about action column in SM50

[Former Member]

Dear Friends,

Please give me explaination about action column (i.e.action perform) in SM50 T code. i.e. sequential read, direct read, delete and so on.

I am waiting for your valuable answer.

Thanks,

Regards,

Sachin

[Former Member · Accepted solution]

Hi

In SM50 ACTION column represents how the workprocess getting data from the DATABASE.We have diffrent actions like

sequential read,direct read.

sequential means no indexs are defined.

direct read means indexs are defined.

kiran kumar.v

[Former Member]

Thanks,

Regards,

Sachin

[Former Member]

My observation and testing shows that when executing of a SQL returns only 1 record,  SAP SM50 would display "direct read". Otherwise, SAP SM50 would display "sequential read". Reading a table via a partial key or full table scan is sequential access. Reading a table using Full primary index is "Direct read". Most of sql read operations falls in these two categories.. There are other situations which is considering as "direct read" and "sequential read". You might refer to section 2.1 in post

http://www.sap-perf.ca/run-sap-sm50-sm66/

[Former Member]

Hi Sachin,

Few Inputs from my side... () ....

direct read: the db-system is able to access the row directly thorugh the specified (primary) key

sequential read: the db-system has to read through the table sequentially to get the result

For More Info on Direct Read check this info aswell.

http://help.sap.com/saphelp_46c/helpdata/EN/d2/cb4598455611d189710000e8322d00/frameset.htm

Basically this is the method of reading the Data from the Database...and this is shown in the SM50 Monitor.

Br,

Sri

Award points for helpful answers