Skip to content

Releases: PawSQL/pawsql-vscode

0.2.0

09 Jun 06:55
@Tomas-PawSQL Tomas-PawSQL
0.2.0
6e30dd8
Compare
Choose a tag to compare
0.2.0 Latest
Latest


Optimize your SQL Queries by Clicks within your VSCode!

Version
Ratings



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


Assets 3
Loading