(PRWEB) October 15, 2009
ActiveBase (http://www.active-base.com) has released ActiveBase SQL Expert™ - a SQL improvement automation tool for Oracle DBAs and developers, improving execution time for business application's SQL requests by 5, 10 or more. This tool is offered at no charge, and is available for download from our web site (http://www.active-base.com/download_sqlexpert.asp)
The ActiveBase SQL Expert™ improves execution time for business application's SQL requests by 5, 10 or more. With quick Installation it is fully operational within minutes, automatically identifying SQL improvements for all types of applications running on Oracle versions 8i and above.
In today's world, confronted with recession and ever growing work load, automation is a proven way for increasing productivity and saving costs. This is why ActiveBase has developed the first automated SQL Improvement Factory™ which provides unprecedented productivity gains in improving application performance on Oracle databases.
With shrunk IT budgets in many of our customers, we have decided to release one of our break-through components ACTIVEBASE SQL EXPERT™ at no charge.
ActiveBase SQL Expert™, the newest module of the ActiveBase's SQL Improvement Factory™, helps the DBA and SQL developer by automating the process of finding the right Oracle Hint, for a given SQL statement.
The "right Hint" is the one that, when added to the original SQL statement, produces the best result (shortest elapsed time or the least CPU or I/O consumption). Oracle Hints can improve the way the Oracle optimizer executes queries without changing its logic.
Through its simple graphic interface, ActiveBase SQL Expert™ completely automates the process of finding the best alternative, without any extra effort.
1. Select un-tuned SQL requests from your applications or from current Oracle SGA
2. Let the Expert automatically find different alternatives (SQL + 'Hints') generating multiple unique execution plans; then let it execute the alternatives against a database to find the best result.
Other modules in the automated SQL Improvement Factory™ include:
ActiveBase Tuning Robot™ - SQL Optimizer Automation Factory.
ActiveBase Performance™ - Fix SQL requests transparently without touching source-code™
For more information, or to schedule an installation or demo, please contact me:
Alon Rosenthal | VP Marketing
866 30 04 022