How to know the Query Execution time

[Former Member]

Hi Gurus,

I want to know the Query execution time for particular query ...because one of the user facing long time to run the query. So i need to know how much time it is taking and also i have to compare for 1 month.

Thanks,

Ravi.

[Former Member]

Hi,

if you have installed your statistics cubes then go to ST03 and check.

Cheers,

Malli..

[former_member189638]

Goto RSRT

Select your Query

Click on Execute and Debug

From the pop-up select the following checkboxes whcih comes under Others

Display Statistics Data

Donot use Cache

Donot Suppress Messages/Warnings.

Execute the Query.

After Executing when you go back you can see the statistics data.

Hope this helps

[Former Member]

Hi,

Check in ST03N or in RSDDSTAT table......

Khaja