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

What is the purpose of table tadir?

1298


Why can't we do it thru some other client?

2018


Explain what is heterogenous system copy and homogenous system copy ?

1030


Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?

1097


Mention what is the difference between sdm and jspm?

1198


I would like to know the version or name of SAP that is implemented in real time?

1160


What is luw (logical unit of work)?

1172


What is the use of commit value while deleting jobs in sap system?

1090


steps to congigure CMS in XI ?

2328


What is the information derived from OSS notes?

7155


If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?

6870


How many times bdls transaction executes for 2 clients

1890


what is the difference b/w 4.6c & 4.7EE?

2277


What is ocm and how to apply ocm patches?

1684


I am attempting to complete a system copy of bw. When I try to go in to rsa1 afterwards I get the error message, "entry in inbound table already exists." What should I do to solve the problem?

1270