Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

performance improving in database access

Former Member
0 Likes
445

in se30 how shd i c the table acess to in the analysis.

for a kna1 table i shd c the no of accesses.

in 4.6c

goto->objecthitlist->database table is not active ...

is there any other way ..

how shd i confirm that performance is incresed after modifying a code.

3 REPLIES 3
Read only

seshatalpasai_madala
Product and Topic Expert
Product and Topic Expert
0 Likes
419

Hi,

You can see the table acess in SQL trace, TCODE- ST05. Check if this transaction is available in your release.

Regards,

Sesh

Read only

Former Member
0 Likes
419

the SE30 can not help you much with that problem (also the database display which appears ponyl if ou use 'no aggregation' )

For details on database accesses you need to run the SQL Trace, the SQL Trace is in any system since a very long time.

See my weblog for details:

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/cs/junior/search/wlg?id_user=46921

Siegfried

Read only

Former Member
0 Likes
419

Are you looking for transaction DB02?

Rob