DB Optimizer (Embarcadero DB Optimizer)

DB Optimizer

Embarcadero has introduced the most powerful, yet simplest database performance tool on the market. On this website you will find the inside track on DB Optimizer from Kyle Hailey, an avid Embarcadero tools user. For official documentation and marketing go to

www.embarcadero.com

Overview:

There 5 icons framed in red above are all that's need to use DB Optimizer

Add a data source. The first step is to add a datasource to work on.

Once a data source has been added then DB Optimzers functionality can be accessed

Profiler - view database load, find top SQL and send SQL to SQL Tuner for tuning
Tuner - supply a SQL statement and have DB Optimizer's SQL Tuner automatically tune the query
Editor - write and debug SQL code with code assistance and quick fixes