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 do transport at OS level?

1897


What are the different types of rfc?

1052


At o.s level where to check for system logs of sap application?

1020


Can you change the profile parameter in the os level? Which one is advisable why?

1215


Hello Guys, If any body looking for "SAP Vendor Invoice Management (VIM) Training", Please Contact Me,We will covers all SAP VIM topics along with end to end ICC, Document pipeline xECM, Enterprise scan etc. Email ID :kakumanusasikanth@gmail.com

1706


Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.

2594


What is a background processing batch scheduler?

1158


What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?

2476


list some common errors faced with jspm while updating java stcks.and solutions.

2571


Hi,My name is Saurabh I have done BMS & currently working in Wipro BPO (1 year). I want to pursue my career in SAP. As I am totally new in the IT field(no course & no experience) Please could you suggest whether to do a certification from Certified institutes or Non Certified institutes.What is the difference? Also, Is MBA necessary to do certification from Certified institutes?

2263


If possible send me screenshot doc for installation of ecc6

1690


What will you do if u got Update failure?

1758


Why do you use DDIC user not SAP* for Support Packs and SPam?

1163


Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?

1024


what are the pre-requisites to apply support patch?

1025