PawSQL , Optimize your SQL Queries by Clicks!

Optimize a SQL Query

1. Optimize in Default Workspace:

   • Click the "Optimize" button in the SQL statement prompt

2. Optimize in Specific Workspace:

   • Click the "Optimize..." button in the SQL statement prompt
   • Select a workspace from the dropdown menu

Features

• Index Advise: Recommend optimal indexes based on input SQL syntax, database objects and statistics information
• Query Rewrite: Recommend semantically equivalent, but more efficient SQLs
• Performance Validation: Ensure better performance after SQL rewrite and index recommendation

Supported Databases

MySQL, PostgreSQL, MariaDB, Oracle, openGauss, KingbaseES, GaussDB, Dameng, RDS for MySQL and etc.

Resources

• Docs of PawSQL

• PawSQL Optimizer

• PawSQL Performance Patroller

• PawSQL Plan Visualizer

🌐 About PawSQL

PawSQL is dedicated to automatic and intelligent database performance optimization. The products provided by PawSQL include:

• PawSQL Cloud, an online automated SQL optimization tool that supports SQL auditing, intelligent query rewriting, cost-based index recommendations, suitable for database administrators and data application developers.
• PawSQL Advisor, an IntelliJ plugin that is suitable for data application developers and can be installed via the IDEA/DataGrip marketplace by searching for "PawSQL Advisor" by name.

Contact Us

Email: service@pawsql.com

Website: https://www.pawsql.com