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

How to set predecessor relationship between two transport requests?

2796


How would you troubleshoot the 'system seems slow'?

1129


What is business kpis ?

1119


How can you find a list of objects that have been repaired in the system?

1306


describe how to setup a printer in SAP or where they would look to research why a user/users can not print?

1093


What are the different types of rfc and explain what transactional rfc is?

1165


How you will give new authorizations?

1891


How to perform a sap-export and import tables in sap from os level?

1354


What are the tools to install java patches?

1175


What is the procedure to applying patches?

1208


describe how SAP handles Memory Management?

1168


How do I know what threshold values to set

2196


Where will u find transport error logs?

2141


What is oracle Architecture?

2180


Hi, Cansomeone please send the system refresh doc , it's very urgent for me. Thanks in advance.

2412