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 statement, if found, what should
be done?

Answer Posted / naveen

Use TCode ST03N.Go to transaction profile and see 0DB Time
and 0 Responce time.
Check the Average sequential Read time by STAT and STAD.
Select the object in Red and

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

While doing implementation do you get any issues?

1780


I have a requirement from the SD people wherein whenver one runs the tcode F-02 (Enter G/L account Policy : Header Data), they should not get the list of all acounts in the ACCOUNT field. But when i go to pfcg to check for restricting the list, i dont find any pertinet auth field for doing so. Isi t something that we can ( as Basis Admin) do or the ABAPpers to do. Maybe the ABAPpers have to program the screen where in they need to restrict the list options. If not so, lemme know the auth field that has to bet set if any.

2185


TMS Configuration?

1935


What are the different user types in sap system that an admin can use while creating a new user?

1132


What is sap market place?

1224


Where can you find a list of object keys included in a transport?

1108


How you can assign an object to 100 roles at time?

1474


What is the use of patches in sap system? Could you name few common patch types?

1235


What is a support package?

1030


What is the use of profile paramater ztta/roll_area?

1142


Explain what is the purpose of tdevc ?

1211


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

1128


User wants lock ASAP then what will u do?

1967


1.how to retrive corrupt file in back up ? 2.what post actives of patching 3.how increase the file size in unix

2049


What is R/3? and what is basis version?

1420