Is there a tool online to optimize a stored procedure or inline sql
I have many complex SQL queries that I would like to optimize. The perfor开发者_开发问答mance on it is pretty bad. Is there an online tool to optimize such queries?
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?
精彩评论