Question:
hi,
In my report is execute very slowly.Then how can find which query is taking more time to execute the report please tell me.
Answer:
SE30 might help...
_________________
The Doc
Magna Grand Docot of the Tuly Idiot Order
2007 Basic Rules
Answer:
You can also do a SQL Trace via ST05 to find long running elements in your program.
_________________
Kind Regards
Rosie Brent
Please remember to search the forum and check the FAQ before posting questions, thank you.
Tuly Idiot most of the time, part-time Guru
Answer:
Step 1. Run the report in Debug mode and step through it.
Step 2. Once you identified the offending SQL (assuming that it's this) then use ST05 to trace the SQL executed and explain the path used.
Step 3.. Change the code accordingly and repeat at Step 1 until acceptable.
Dr Sidewalk
_________________
"In the middle of difficulty lies opportunity" - Albert Einstein
"Money isn't everything in life, unless you don't have it". David King
"Fail to plan, plan to fail"
"Success is a journey, not a destination."