Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to find Expensive SQL Statements? How to solve?

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


Please Help Members By Posting Answers For Below Questions

Explain logon load balancing?

1129


What is JVM switch. Why JVM switch is required ?

2606


Myself Rahul am MBA(Mkt)having 1.5 years marketing experience.and in SAP-SD for 1 years experience.am looking for job.so pl anywher opening then pl let me revert.

2198


At os level how you can change the number of work process? How you can analyze the status of work process at os level?

1073


what is the difference b/w 4.7EE & ECC5.0?

2416


Mention what is the purpose of table usr02?

1086


Explain what is luw (logical unit of work)?

1051


the difference between part number and serial number

3158


User wants lock ASAP then what will u do?

1920


What is XI3.0? Explain XI

1216


What is upgrade process? And how u will do that?

1812


Where will you change the parameters in three profiles?

1202


how can i change access to a user who is having access for SPRO display only to change access in sPro

2336


Where is the Deletion Flag or Indicator used in archiving process?

3378


Explain kernel upgrade?

1057