---
title: "#sql-query-optimization articles | Hashnode"
description: "Explore 5 articles tagged #sql-query-optimization on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/sql-query-optimization"
---

Tag

# #sql-query-optimization

5 posts · 0 followers

[tcd93](https://hashnode.com/@denda) · [Feb 3](https://hashnode.com/posts/unlocking-the-secrets-of-mssql-plan-optimization-a-comprehensive-guide/698197d07dc5deb9a0027d5c)

### [Unlocking the Secrets of MSSQL Plan Optimization: A Comprehensive Guide](https://tcd93-de.hashnode.dev/unlocking-the-secrets-of-mssql-plan-optimization-a-comprehensive-guide?utm_source=hashnode&utm_medium=feed)

An introduction to Microsoft SQL Server's plan optimizer & common operators, and provide an more in-depth view & analysis of slow queries

23 min read · [tcd93-de.hashnode.dev](https://tcd93-de.hashnode.dev/unlocking-the-secrets-of-mssql-plan-optimization-a-comprehensive-guide?utm_source=hashnode&utm_medium=feed)

[SQLFlash](https://hashnode.com/@SQLFlash) · [Jun 6, 2025](https://hashnode.com/posts/sql-rewriting-vs-indexing-how-ai-powered-structural-optimization-achieves-20x-scalability-gains/684296f3c4a7f656d7e97177)

### [SQL Rewriting vs Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains](https://sqlflash.hashnode.dev/sql-rewriting-vs-indexing-how-ai-powered-structural-optimization-achieves-20x-scalability-gains?utm_source=hashnode&utm_medium=feed)

AI-driven SQL rewriting and indexing optimize MySQL, achieving 20x scalability gains and sustainable data growth

17 min read · [sqlflash.hashnode.dev](https://sqlflash.hashnode.dev/sql-rewriting-vs-indexing-how-ai-powered-structural-optimization-achieves-20x-scalability-gains?utm_source=hashnode&utm_medium=feed)

[SQLFlash](https://hashnode.com/@SQLFlash) · [May 30, 2025](https://hashnode.com/posts/mysql-like-optimization-100x-faster-queries/6839759c50b80d9b366c7ce7)

### [MySQL LIKE Optimization: 100x Faster Queries!](https://sqlflash.hashnode.dev/mysql-like-optimization-100x-faster-queries?utm_source=hashnode&utm_medium=feed)

Discover how SQLFlash optimizes MySQL LIKE queries for 100x faster performance using index-aware SQL rewriting and range scans

4 min read · [sqlflash.hashnode.dev](https://sqlflash.hashnode.dev/mysql-like-optimization-100x-faster-queries?utm_source=hashnode&utm_medium=feed)

[SQLFlash](https://hashnode.com/@SQLFlash) · [May 13, 2025](https://hashnode.com/posts/leetcode-hardest-sql-185-is-the-best-solution-still-slow/682556a5f7e2ea9fc1763b5d)

### [Leetcode Hardest SQL 185: Is the Best Solution Still Slow?](https://sqlflash.hashnode.dev/leetcode-hardest-sql-185-is-the-best-solution-still-slow?utm_source=hashnode&utm_medium=feed)

LeetCode's SQL solutions use window functions and subqueries; window functions generally perform better on large datasets

4 min read · [sqlflash.hashnode.dev](https://sqlflash.hashnode.dev/leetcode-hardest-sql-185-is-the-best-solution-still-slow?utm_source=hashnode&utm_medium=feed)
