Skip to main content
PawSQL integrates query-optimization best practices to help developers and DBAs solve SQL performance problems through query rewrite and intelligent index recommendation, and records optimization history for review, tracking, and sharing.

​
Prerequisites

A workspace whose tables, views, indexes, and statistics match the environment you optimize against.

​
Concepts in PawSQL

  • Workspace: the environment (tables, views, indexes, and related statistics) you optimize against.
  • Workload: a single DML statement or a set of DML statements you want to optimize and analyze.
  • Optimization: an operation PawSQL performs against a workspace to optimize a workload, typically including SQL audit, rewrite, and index recommendation.

​
Four steps to optimize

1

Create a workspace

Build a workspace from a database connection, an uploaded DDL file, or manual DDL input so tables, indexes, and statistics match the real environment.
2

Input SQL to optimize

Provide SQL from a text box, a SQL file, database logs, or a MyBatis Mapper file.
3

Create an optimization task

Configure basic options, validation, index recommendation, and rule settings, then submit.
4

Read the results

Drill from the summary into per-SQL details to review rewrite, audit, index, and validation results and compare execution plans.

​
Pages in this section

Input SQL to optimize

Create and configure an optimization task

Read the results

Evaluate and apply suggestions

​
Choose an entry point

​
Expected Result

A completed optimization task with SQL audit, rewrite, and index recommendation results that you can review, track, and share.

​
Verification

Work through the four steps—create a workspace, input SQL, create a task, and read the results—and confirm the summary and per-SQL details are complete.

​
Next steps