Ttcd93·Feb 3Unlocking the Secrets of MSSQL Plan Optimization: A Comprehensive GuideAn introduction to Microsoft SQL Server's plan optimizer & common operators, and provide an more in-depth view & analysis of slow queries23 min read·tcd93-de.hashnode.dev
SSQLFlash·Jun 6, 2025SQL Rewriting vs Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability GainsAI-driven SQL rewriting and indexing optimize MySQL, achieving 20x scalability gains and sustainable data growth17 min read·sqlflash.hashnode.dev
SSQLFlash·May 30, 2025MySQL LIKE Optimization: 100x Faster Queries!Discover how SQLFlash optimizes MySQL LIKE queries for 100x faster performance using index-aware SQL rewriting and range scans4 min read·sqlflash.hashnode.dev
SSQLFlash·May 13, 2025Leetcode Hardest SQL 185: Is the Best Solution Still Slow?LeetCode's SQL solutions use window functions and subqueries; window functions generally perform better on large datasets4 min read·sqlflash.hashnode.dev