Skip to Content
author's profile photo Former Member
Former Member

How to know the Query Execution time

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 05:23 AM

    Hi,

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

    Khaja

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 30, 2008 at 05:38 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 06:29 AM

    Hi,

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

    Cheers,

    Malli..

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.