Skip to main content

PawSQLTutorial Insides API Blog FAQs

Self Host CLOUD

English
中文

All PawSQL Blogs!

PawSQL for OceanBase Database
PawSQL for Jetbrains - Optimize your SQL Queries within Jetbrains IDEs
PawSQL for VSCode - Optimize your SQL Queries within VSCode
PawSQL for DM/KES: Comprehensive Performance Optimization Solution for Emerging Databases
PawSQL Optimization Case: TPC-H Query 9 Performance Improved by 1195.14%
How Does PawSQL Optimize Correlated Scalar Subqueries?
PawSQL's Smart Index Recommendation Helps Improve Window Function Performance by 50 Times
SAT-TC Rewrite
NPE Rewrite
Explicitly Disable Sorting of Result Set
Query Folding
Qualified Subquery Rewrite
Projection Pushdown
Outer to Inner Join Conversion
When OR Just Won't Do: Using UNION for Higher SQL Performance
Join Elimination
IN Subquery Optimization
Calculation Disables Index Usage
Implicit Data Type Conversion
Counting Optimization
Plan Visualization for MySQL
Optimize TPCH Queries with PawSQL
Order by Random Optimization
Principles of Database Index Design
Types of Database Index
Avoid using LIMIT in UPDATE/DELETE
9 Reasons to Avoid Using SELECT * and 2 Exceptional Cases
Avoid using STRAIGHT_JOIN
Node Type of Explain Tree
Four Pitfalls of SQL Processing with Null Values
Avoid Using Natural Join
Mixed Sort Directions Disable Index Usage
Avoid COUNT DISTINCT on Nullable Multi-Columns
Avoid Using CROSS JOIN

Tags

A

aduit6
audit1

B

blog30

D

database performance1
Datagrip1
DM Database1

I

Idea1
Index Recommendation3

J

Jetbrains1

K

KES1
Kingbase1

O

oceanbase1
optimization6
optimize21

P

pawsql33
PawSQL1
Performance Insight1
Plugin2
ppt1

Q

Query Rewriting3

R

rewrite13

S

scalar subquery1
Slow Queries1
SQL6
SQL optimization4
SQL review1

T

TPC-H1

V

vscode1

W

window functions1

Tutorial

SQL Auditing
Rewrite Optimization
Index Recommendation

Community

Discord
Twitter

More

Built with Docusaurus

© 2025 PawSQL. 京ICP备2024054076号-1