Tag: Window Functions

2 posts

Optimizing MySQL TopN Queries: Window Function Performance Comparison and Optimization Strategies

This report compares MySQL TopN query optimizations using window functions, showcasing a two-order performance boost via CTE and LIMIT strategies with SQLFlash. Original 8-second queries optimized to 10ms through execution plan analysis and indexing strategies.

Rebooter.S

May 29, 2025

Leetcode Hardest SQL 185: Is the Best Solution Still Slow?

Explore LeetCode's No.185 SQL solutions, comparing subquery and window function performance with SQLFLASH optimization insights.

Rebooter.S

Apr 29, 2025