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.
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
P3
Delivery Time
P3
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.
catalog（1）
Download All Catalogs
Company information
Our company consists of specialists who understand the field of database operations. We continue to provide services that contribute to the IT society as a partner that supports the system infrastructure of companies, solving challenges in database operations together with our customers. If you are responsible for the information systems department and have any issues or concerns regarding infrastructure centered around databases, please feel free to consult with us.