I have many complex SQL queries that I would like to optimize. The performance on it is pretty bad. Is there an online tool to optimize such queries?
Asked
Active
Viewed 1.5k times
3
-
2Anything that can be optimised by a tool will probably be optimised by the database's optimiser already. – lins314159 Jan 13 '10 at 06:01
1 Answers
3
If you are talking about MS SQL Server, then Yes: SQL Profiler is part of SQL Server.
Optimizing is not the easiest thing to do!
This might be of help: MS SQL Server 2008 - How Can I Log and Find the Most Expensive Queries?
Community
- 1
- 1
Mitch Wheat
- 288,400
- 42
- 452
- 532