If Report Definition is taking much time to execute, what are your steps to debug it

• Execute report definition stand-stalone with tracer on with DB query setting. Capture the query.
• Or look at clipboard page pyReportContentPage which would give exact query that was run.
• If we have query we can easily identify why it is taking much time.
• We can watch out if any unoptimized properties used in the report.
• We can check if indexing would improve the performance.