PawSQL Optimize

PawSQL integrates the best practices of query optimization in the database industry and provides powerful SQL audit and rewrite optimization functions. It also integrates the Paw Index Advisor index recommendation engine to provide cost-based index recommendations for slow queries.

PawSQL Cloud is the cloud version of PawSQL Advisor and now it's available at https://www.pawsql.com.

Concepts in PawSQL Cloud

• A Workspace is the environment(tables, views, indexes, and associated statistics) you want to do the query optimization against.

• A Workload is a single DML SQL statement or a set of DML SQL statements you want to optimize and analyze.

• A Optimization is an operation you defines and PawSQL performs to optimize a workload against a workspace.

Three Steps to set up an optimization task

🗃️ 1. Create a workspace

6 items

🗃️ 2. Create a workload

6 items

📄️ 3. Setup an Optimization

You can configure your query optimization to control the execution process and results of your query optimization.

📄️ 4. Explain the Output

Optimization Summary