How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 21251 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rout
U can find expensive SQL statements using T_code:ST05 /SM50
U can solve this either by killing the process or find out
the table that has been accessed adn creat some indexes ,so
that it can be accessed easily or get the workload
statestics information and tune the system.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What are the categories to execute sap background jobs?
How many types of printer you have configured? How do you differentiate between them?
What are the scripts you can create for security by using LSMW??
How should I set priority for Printing say like user, teamlead, project manager?
Explain checkpoint?
How you connect ECC to EP?
What are common background jobs that will run in your system?
What is development class? Why to create the development class?
1.how to retrive corrupt file in back up ? 2.what post actives of patching 3.how increase the file size in unix
How to transfer request which is created directly on quality server & has to be moved to in production server?
Mention what is the purpose of table usr02?
how to do system refresh?not the client copy but the-standard-system-refresh.
What are the different types of rfc?
what is the procedure for java stack upgradation?
what are the main issues you faced in the implementation project?
