DB management product 'Toad' with SQL automatic tuning feature.

Added to bookmarks
Bookmarks list

Bookmark has been removed
Bookmarks list

You can't add any more bookmarks

By registering as a member, you can increase the number of bookmarks you can save and organize them with labels.
Free membership registration

last updated：Jan 19, 2024

コーソル

Official site

Automatic SQL tuning, graphing of Statspack/AWR reports, and object comparison between source and target, among various other scenarios.

"Toad" is a database management tool for developers and database administrators, with over 4 million licenses sold worldwide. It is available for Oracle Database and SQL Server. 【Feature Introduction】 ■ Automatic SQL Tuning → Simply paste the SQL you want to tune on the screen and press the analyze button! Toad automatically generates SQL rewrite patterns that change the execution plan, executes the rewritten SQL in the connected environment, and measures the time. ■ Comparison and Modification of Database/Schema/Table Data Between Databases → You can compare various database objects between the source and target databases during data migration. ■ Graphical Display of STATSPACK and AWR Reports → Normally, graphing Statspack or AWR reports is done through Excel, but with Toad, you can directly graph the reports without going through Excel.

Related Link - https://cosol.jp/license/toad-for-oracle/

Inquire About This Product

basic information

【Other Functions】 ■Bidirectional conversion between ANSI-compliant SQL and Oracle-compliant SQL 　→When the database product changes, SQL executed from the application can be rewritten to ANSI-compliant SQL using the tool. ■Table data CSV output / Output data masking 　→Table data can be easily output to CSV, and during CSV output, masking can be applied to any specified string. ■Object DDL generation 　→Object DDL can be easily generated from Toad. ■Performance measurement support function 　→SQL executed in the production environment can be captured and replayed in any environment. ■DB health check 　→You can check whether it is operating healthily across multiple databases. *For more details, please refer to our company website. ■Introduction to Toad 　https://cosol.jp/license/toad/ ■Technical information about Toad (Toad Tips) 　https://cosol.jp/knowledge/toad-tips/

Price information

Multiple editions are available, and the features available vary by edition. License type: Perpetual license with maintenance Contract period: 1 year to multiple years Billing unit: Seats (number of users) Price: Available at a low cost. Please contact us for details. *The price range is based on the edition that is most commonly used.

Price range

Delivery Time

Applications/Examples of results

■Case Study of Tuning Delayed SQL Using Toad ●Case 1: Customer Using Oracle Database Extracted SQLs with execution times around 10 seconds and aimed to reduce execution time by half using Toad for tuning. Results: - SQL1 Before Tuning: 42.21 seconds After Tuning: 19.78 seconds - SQL2 Before Tuning: 8.57 seconds After Tuning: 2.79 seconds - SQL3 Before Tuning: 8.57 seconds After Tuning: 1.46 seconds ●Case 2: Customer Using SQL Server Performance degradation occurred in many SQLs, so tuning was performed using Toad. Results: - Tuning of all slow SQLs was completed in just one day. - Performance improved by up to 180 times to 2 times.

Detailed information

SQL can be automatically tuned with SQL Optimizer. SQL Optimizer is a feature exclusive to Toad.
It is also possible to debug stored programs coded in PL/SQL.
Even the export/import of high-difficulty data can be easily executed by anyone using Toad.
Typically, Statspack reports and AWR reports, which can only be verified with numerical data, can be automatically graphed and displayed using Toad.
When migrating data, comparing the database objects and table data of the source and destination can be easily and quickly executed using Toad. You can also leave the comparison results and the generation of correction scripts to Toad.