Quest's Toad apparently allows one to optimize SQL for Oracle. One can ping a server with the tool and the tool will try to rewrite existing, specified SQL in different ways while gauging the roundtrip speed of each implemenation and eventually picking a winner. Quest has a comparable tool for MSSQL (I think). SSMS Tools is something else I heard of today. It allows you to do other things that you cannot do with SSMS (SQL Server Management Studio) standalone such as save your query history.
No comments:
Post a Comment