
Advanced optimization enables DBAs to tune SQL effectively in production. SQL Optimization - Provides developers with a way to tune and optimize SQL statements and database code without relying on a DBA.Static code review (Oracle) - Ensures code meets required quality level using a rules-based system.Unit Testing (Oracle) - Ensures code is functionally tested before it is released into production.


He called it Tool for Oracle Application Developers, shortened to "TOAD". A Toad product for data preparation supports many data platforms.Ī practicing Oracle DBA, Jim McDaniel, designed Toad for his own use in the mid-1990s. The Toad toolset runs against Oracle, SQL Server, IBM DB2 (LUW & z/OS), SAP and MySQL. Toad is a database management toolset from Quest Software for managing relational and non-relational databases using SQL aimed at database developers, database administrators, and data analysts. JSTOR ( September 2016) ( Learn how and when to remove this template message).Unsourced material may be challenged and removed.

Please help improve this article by adding citations to reliable sources. This article needs additional citations for verification.
