How to analyse performance runtime of planning query when executed in RSRT
You execute a planning query in RSRT and it is taking long time to display the result. You want to know in which steps the time is spent which is causing the long runtime.
Below are the steps you need to do to check the runtime statistics:
1. Enter the query technical name in Query field.
Then click on button "Execute + Debug".
2. Select the option "Display Statistics Data"
3. Once your query is executed , go back using "Back" arrow as show below.
4. Now you will get the screen "Statistics Data for Query Runtime".
This will contain the details regarding the steps which consumed how much time.
This will help you to identify the performance issues for query when executed directly in RSRT.