Skip to main content

PawSQLTutorial Insides API Blog FAQs

Self Host CLOUD

English
中文

All PawSQL Blogs!

Top LLMs in SQL Semantic Reasoning：DeepSeek r1, GPT-4o, and Claude 3.7 Sonnet
Downloads Exceed 10,000! PawSQL Advisor: How a Domestic SQL Optimization Tool Broke Through Difficulties
PawSQL for TDSQL: Complete Performance Optimization Guide for Distributed Databases
PawSQL for SQL Server, Complete Performance Optimization Guide for MSSQL
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

博

博客3

插

插件1

数

数据库性能2

优

优化3

A

aduit6
audit1

B

blog30

D

database performance1
Datagrip2
DM Database1

I

Idea2
Index Recommendation3

J

Jetbrains2

K

KES1
Kingbase1

O

oceanbase1
optimization6
optimize21

P

pawsql36
PawSQL1
Performance Insight1
Plugin2
ppt1

Q

Query Rewriting3

R

rewrite13

S

scalar subquery1
Slow Queries1
SQL9
SQL optimization4
SQL review1
SQL Server1
SQL审核2
SQL优化3

T

tdsql1
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