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