How to can i minimize the report generation time in t-sql

Question

if time taken is 3 minutes I need to it run in 30sec

Answer 1

I don't have much specific experience with t-sql, but I think each report need to be analyzed and optimized individually. In general SQL, usually, there's good practices, but there's not an only simple way to optimize every query to the database.