Many times, you don’t have the luxury of tuning during development. You are working in a production environment when performance problems crop up.
You can use Unicenter Plan Analyzer Option for SQL-Station and Unicenter Detector Option for SQL-Station to capture SQL, and then go into Plan Analyzer’s tuning framework to analyze and solve problems with indexing schemes, access paths, and other elements.
