Tagged articles

45 articles

Page 1 of 1

Apr 3, 2026 · Databases

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

This article presents ten practical MySQL advanced techniques—including EXPLAIN analysis, composite and covering indexes, index condition push‑down, prefix indexes, window functions, CTEs, JSON handling, partition tables, join optimizations, variables, online DDL, and generated columns—each illustrated with real‑world SQL examples and execution‑plan screenshots to boost efficiency in high‑volume, high‑concurrency environments.

Advanced SQLCTEIndex Optimization

0 likes · 16 min read

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

SpringMeng

Mar 9, 2026 · Databases

10 Advanced MySQL Techniques to Supercharge Query Performance

This article walks through ten high‑level MySQL tricks—including EXPLAIN analysis, advanced indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user‑defined variables, online DDL, and generated columns—showing concrete examples, performance trade‑offs, and step‑by‑step guidance for turning slow queries into lightning‑fast operations.

CTEPartitioningSQL

0 likes · 15 min read

10 Advanced MySQL Techniques to Supercharge Query Performance

Spring Full-Stack Practical Cases

Jan 7, 2026 · Databases

Master MySQL CTE, Window Functions, and Query Optimization with Real‑World Examples

This article presents a comprehensive guide to advanced MySQL techniques, covering CTEs, window functions, and query optimization strategies, complete with step‑by‑step code examples, performance tips, and practical demonstrations such as ranking employees and creating materialized views.

CTESQL OptimizationWindow Functions

0 likes · 9 min read

Master MySQL CTE, Window Functions, and Query Optimization with Real‑World Examples

Linux Tech Enthusiast

Dec 25, 2025 · Databases

10 Advanced SQL Query Techniques Every Data Professional Should Master

This article presents ten advanced SQL concepts—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, cumulative sums, and date‑time manipulation—each explained with concrete examples and code snippets.

CTEData PivotRanking Functions

0 likes · 11 min read

10 Advanced SQL Query Techniques Every Data Professional Should Master

Su San Talks Tech

Dec 22, 2025 · Databases

10 Advanced SQL Techniques Every Data Professional Should Master

This article presents ten powerful SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations, cumulative sums, and datetime manipulation—complete with explanations and runnable code examples for data analysts and engineers.

CTEWindow Functionsdata analysis

0 likes · 13 min read

10 Advanced SQL Techniques Every Data Professional Should Master

Ray's Galactic Tech

Dec 15, 2025 · Databases

10 Advanced MySQL Techniques to Write Faster, Cleaner SQL

Discover ten powerful MySQL features—including CTEs, window functions, conditional aggregation, JSON handling, generated columns, and UPSERT tricks—illustrated with real‑world examples and performance tips, so you can write SQL that is more efficient, maintainable, and production‑ready.

CTEGenerated ColumnsJSON

0 likes · 15 min read

10 Advanced MySQL Techniques to Write Faster, Cleaner SQL

Java Backend Technology

Oct 31, 2025 · Databases

10 Essential MySQL Tricks to Boost Performance and Simplify Queries

This article presents ten practical MySQL techniques—from using JSON columns for flexible data to leveraging CTEs, window functions, and advanced clauses like WITH ROLLUP and INSERT IGNORE—each illustrated with real‑world scenarios and ready‑to‑run SQL code to improve query efficiency and developer productivity.

CTEDatabase QueriesJSON

0 likes · 11 min read

10 Essential MySQL Tricks to Boost Performance and Simplify Queries

Code Ape Tech Column

Aug 13, 2025 · Databases

Master 10 Essential Advanced SQL Concepts Every Data Professional Needs

This article outlines ten crucial intermediate‑to‑advanced SQL techniques—including common table expressions, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, cumulative sums, and date‑time manipulation—providing explanations and practical query examples for data professionals.

CTEWindow Functionsdatabase

0 likes · 11 min read

Master 10 Essential Advanced SQL Concepts Every Data Professional Needs

Spring Full-Stack Practical Cases

Aug 8, 2025 · Databases

Master SQL Execution Order, Joins, CTEs & Window Functions

This article provides a comprehensive guide to essential SQL concepts for backend developers and data engineers, covering query execution order, core commands, various join types, common table expressions (including recursive CTEs), window functions, and performance optimization techniques such as table scans and indexing, complete with practical code examples and visual illustrations.

CTEJoinsPerformance Optimization

0 likes · 10 min read

Master SQL Execution Order, Joins, CTEs & Window Functions

php Courses

Jul 22, 2025 · Databases

10 Must‑Know Advanced SQL Tricks to Boost Your Development Efficiency

This article presents ten essential advanced SQL techniques—including EXPLAIN, window functions, CTEs, bulk operations, index optimization, transactions, JSON handling, temporary tables, proper NULL handling, and recursive queries—to help developers write more efficient, maintainable, and powerful database code.

Advanced QueriesCTEDatabase Optimization

0 likes · 8 min read

10 Must‑Know Advanced SQL Tricks to Boost Your Development Efficiency

Top Architecture Tech Stack

Dec 5, 2024 · Databases

Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Predicate Pushdown, Early Range Reduction, and CTEs

This article explains common MySQL performance pitfalls such as large‑offset LIMIT queries, implicit type conversion, sub‑query updates, mixed sorting, inefficient EXISTS clauses, predicate push‑down limitations, and demonstrates how rewriting with proper indexes, JOINs, early range reduction, and WITH (CTE) statements can reduce execution time from seconds to milliseconds.

CTEPredicate PushdownSQL Optimization

0 likes · 12 min read

Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Predicate Pushdown, Early Range Reduction, and CTEs

Liangxu Linux

Sep 28, 2024 · Databases

10 Advanced SQL Concepts Every Data Scientist Should Master

This guide walks through ten essential advanced SQL concepts—including CTEs, recursive queries, temporary functions, CASE‑based pivoting, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations, cumulative totals, and date‑time manipulation—providing clear explanations and runnable examples to help data‑science professionals ace interview challenges.

Advanced QueriesCTEData Science

0 likes · 11 min read

10 Advanced SQL Concepts Every Data Scientist Should Master

Liangxu Linux

Sep 19, 2024 · Databases

10 Advanced SQL Concepts Every Data Scientist Should Master

This guide walks through ten essential advanced SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations with LAG/LEAD, cumulative sums, and date‑time manipulation—to help data professionals ace interview challenges and write cleaner, more powerful queries.

Advanced SQLCTEData Science

0 likes · 11 min read

Code Ape Tech Column

Jul 5, 2024 · Databases

10 Essential Intermediate to Advanced SQL Concepts

This article presents ten crucial intermediate‑to‑advanced SQL concepts—including CTEs, recursive queries, temporary functions, CASE pivots, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations, cumulative totals, and date‑time manipulation—each explained with clear examples and code snippets.

CTEData PivotRecursive Queries

0 likes · 11 min read

10 Essential Intermediate to Advanced SQL Concepts

Liangxu Linux

Apr 7, 2024 · Databases

8 Proven MySQL Query Optimizations to Slash Execution Time

This article explains common MySQL performance pitfalls such as large‑offset pagination, implicit type conversion, inefficient UPDATE/DELETE joins, mixed ordering, EXISTS subqueries, predicate push‑down, early data reduction, and intermediate result set push‑down, and provides concrete rewrites that turn multi‑second queries into millisecond‑level executions.

CTEJoinsindexing

0 likes · 13 min read

8 Proven MySQL Query Optimizations to Slash Execution Time

Top Architect

Apr 2, 2024 · Databases

Ten Advanced SQL Concepts Every Data‑Science Interview Candidate Should Master

This article explains ten advanced SQL techniques—including common table expressions, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations, cumulative sums, and date‑time manipulation—providing clear explanations and complete query examples to help readers ace data‑science interview questions.

CTEData Science InterviewsSQL

0 likes · 14 min read

Ten Advanced SQL Concepts Every Data‑Science Interview Candidate Should Master

Selected Java Interview Questions

Mar 12, 2024 · Databases

Understanding Recursive Queries in MySQL with Practical Examples

This article explains MySQL recursive queries using WITH RECURSIVE, detailing their structure, execution process, common use cases, and provides a step‑by‑step example with table creation, data insertion, and a paginated hierarchical query.

CTERecursive querySQL

0 likes · 9 min read

Understanding Recursive Queries in MySQL with Practical Examples

Programmer DD

May 24, 2023 · Databases

Why SQL Struggles with Complex Queries and How SPL Offers a Solution

This article examines the inherent difficulties of SQL when handling multi‑step, ordered, and object‑referencing queries, illustrates them with practical examples, and introduces the Structured Process Language (SPL) as a more expressive alternative for data processing tasks.

CTESPLSQL

0 likes · 16 min read

Why SQL Struggles with Complex Queries and How SPL Offers a Solution

Java Architect Essentials

Jan 30, 2023 · Databases

Boost MySQL Performance: 9 Proven Query Optimization Techniques

This article presents nine practical MySQL optimization methods—including smarter LIMIT usage, avoiding implicit type conversion, rewriting subqueries as joins, handling mixed sorting, replacing EXISTS with joins, pushing conditions into subqueries, early range reduction, and using CTEs—to dramatically improve query execution time across common scenarios.

CTEDatabase IndexesJOIN

0 likes · 14 min read

Boost MySQL Performance: 9 Proven Query Optimization Techniques

Laravel Tech Community

Jan 2, 2023 · Databases

Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, and More

This article presents a series of practical MySQL performance‑tuning methods—including smarter LIMIT usage, handling implicit type conversion, rewriting UPDATE/DELETE with JOIN, mixed‑order optimization, EXISTS replacement, condition push‑down, early result filtering, and CTE usage—to dramatically reduce query execution time across common scenarios.

CTEJOINLIMIT

0 likes · 13 min read

Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, and More

Liangxu Linux

Aug 14, 2022 · Databases

Master 10 Advanced SQL Concepts for Data Science Interviews

This guide walks you through ten essential advanced SQL techniques—including CTEs, recursive queries, temporary functions, CASE pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, running totals, and date‑time manipulation—providing clear explanations and practical code examples to boost your interview performance.

Advanced QueriesCTEData Science Interviews

0 likes · 12 min read

Master 10 Advanced SQL Concepts for Data Science Interviews

21CTO

Jul 27, 2022 · Databases

Master 10 Essential Advanced SQL Concepts for Data Professionals

This article presents ten crucial intermediate‑to‑advanced SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, cumulative sums, and date‑time manipulation—to help data professionals ace interview questions and write cleaner, more powerful queries.

CTEInterview PreparationSQL

0 likes · 11 min read

Master 10 Essential Advanced SQL Concepts for Data Professionals

Python Programming Learning Circle

Jul 20, 2022 · Databases

10 Essential SQL Concepts for Interview Preparation

This article presents ten core SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, cumulative sums, and date‑time manipulation—each explained with clear descriptions and practical query examples to help candidates ace data‑analysis interviews.

CASE WHENCTESQL

0 likes · 11 min read

10 Essential SQL Concepts for Interview Preparation

dbaplus Community

Jun 28, 2022 · Databases

Master 10 Advanced SQL Concepts Every Data Scientist Should Know

This article presents ten essential advanced SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking windows, delta calculations, cumulative totals, and date‑time manipulation—each explained with clear examples and code snippets for interview preparation.

CASE WHENCTEData Science Interviews

0 likes · 11 min read

Master 10 Advanced SQL Concepts Every Data Scientist Should Know

IT Xianyu

Aug 17, 2021 · Databases

Key New Features of MySQL 8.0 for Relational Databases

MySQL 8.0 introduces several relational‑database enhancements, including invisible indexes for performance tuning, persistent configuration via SET PERSIST, default utf8mb4 character set, support for Common Table Expressions, and window functions, each illustrated with practical SQL examples.

8.0CTESQL

0 likes · 7 min read

Key New Features of MySQL 8.0 for Relational Databases

dbaplus Community

Aug 11, 2021 · Databases

Turn Slow MySQL Queries into Millisecond Performance with Smart Rewrites

This article explains common MySQL performance pitfalls such as large‑offset LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS clauses, and condition pushdown, and shows how to rewrite each pattern using indexes, JOINs, UNION ALL, CTEs and early filtering to achieve execution times measured in milliseconds instead of seconds.

CTEJOINSQL Optimization

0 likes · 13 min read

Turn Slow MySQL Queries into Millisecond Performance with Smart Rewrites

Aikesheng Open Source Community

Jan 12, 2021 · Databases

How to Quickly Find Missing Auto‑Increment Primary Key Values in MySQL

This article explains several efficient methods—including shell scripts, generated series tables, JSON functions, and MySQL 8.0 recursive CTEs—to quickly locate missing auto‑increment primary key values in a MySQL table, comparing their performance and suitability.

CTESQLgap detection

0 likes · 12 min read

How to Quickly Find Missing Auto‑Increment Primary Key Values in MySQL

Practical DevOps Architecture

Jan 4, 2021 · Databases

New MySQL 8 Features: Invisible Indexes, Persistent Settings, UTF8MB4, CTEs, and Window Functions

This article introduces several MySQL 8 enhancements—including invisible indexes for performance testing, the SET PERSIST command for durable configuration changes, default UTF8MB4 encoding, Common Table Expressions for clearer queries, and window functions for ranking and aggregation—illustrated with practical SQL examples.

CTEWindow Functionsindexes

0 likes · 6 min read

New MySQL 8 Features: Invisible Indexes, Persistent Settings, UTF8MB4, CTEs, and Window Functions

Open Source Linux

Oct 23, 2020 · Databases

Boost MySQL Performance: 8 Proven Query Optimization Techniques

This article explores eight common MySQL performance pitfalls—including inefficient LIMIT usage, implicit type conversion, subquery updates, mixed sorting, EXISTS clauses, condition push‑down, early result narrowing, and intermediate result push‑down—and provides rewritten SQL examples that dramatically reduce execution time.

CTESQLindexing

0 likes · 13 min read

Boost MySQL Performance: 8 Proven Query Optimization Techniques

DevOps Coach

Aug 1, 2020 · Databases

Boost PostgreSQL Performance: Essential DBA Tricks Every Developer Should Know

This article presents a collection of practical PostgreSQL DBA techniques—including selective updates, bulk‑load optimizations, CTE‑based deduplication, partial and BRIN indexes, correlation tuning, and transactional DDL tricks—to help developers reduce database bottlenecks, improve query speed, and avoid common performance pitfalls.

BRINCTEDevOps

0 likes · 33 min read

Boost PostgreSQL Performance: Essential DBA Tricks Every Developer Should Know

Aikesheng Open Source Community

Jun 18, 2020 · Databases

How to Query MySQL Metadata Locks Using the MySQL Shell Plugin

This article explains MySQL's metadata lock mechanism and demonstrates how to use the ext.check.get_locks() function from the MySQL Shell plugin—along with a supporting SQL query—to list lock owners, statements, and lock types, including setup steps for MySQL 5.7.

CTEPerformance SchemaSQL query

0 likes · 3 min read

How to Query MySQL Metadata Locks Using the MySQL Shell Plugin

ITPUB

Feb 11, 2020 · Databases

Boost MySQL Performance: 8 Proven SQL Optimization Techniques

This article presents eight practical MySQL optimization strategies—including LIMIT redesign, implicit type conversion fixes, JOIN rewrites for updates/deletes, mixed sorting tricks, EXISTS elimination, condition push‑down, early data reduction, and intermediate result set push‑down—each illustrated with before‑and‑after queries, execution plans, and measurable speed improvements.

CTELIMIT redesignSQL Optimization

0 likes · 7 min read

Boost MySQL Performance: 8 Proven SQL Optimization Techniques

Aikesheng Open Source Community

Jul 25, 2019 · Databases

Using LATERAL and Recursive CTEs in MySQL to Count Direct and Indirect Employee Reports

This article explains how MySQL's LATERAL join and recursive CTE can be used to compute the number of direct and indirect reports for each employee, demonstrating lateral external references, non‑lateral references, query execution details, and EXPLAIN output in MySQL 8.0.14 and later.

CTELATERALRecursive query

0 likes · 8 min read

Using LATERAL and Recursive CTEs in MySQL to Count Direct and Indirect Employee Reports

Java High-Performance Architecture

Sep 29, 2018 · Databases

Master Hierarchical Queries with CTEs: Recursive Techniques for Category Trees

This article explains how Common Table Expressions (CTEs) simplify hierarchical queries in SQL, covering both non‑recursive and recursive forms, providing step‑by‑step examples for retrieving child, parent, and root categories using MySQL 8 and PostgreSQL 10, along with test data and execution results.

CTEPostgreSQLRecursive Queries

0 likes · 8 min read

Master Hierarchical Queries with CTEs: Recursive Techniques for Category Trees

dbaplus Community

Aug 20, 2018 · Databases

Unlock PostgreSQL’s Powerful SQL Features: CTEs, UPSERT, Sampling, and More

This article explores PostgreSQL’s advanced SQL capabilities—including Common Table Expressions (WITH), batch inserts, the RETURNING clause, UPSERT with ON CONFLICT, TABLESAMPLE methods, aggregation functions like string_agg and array_agg, and a range of window functions—providing practical examples, performance insights, and guidance for real‑world use.

CTEPostgreSQLSQL

0 likes · 17 min read

Unlock PostgreSQL’s Powerful SQL Features: CTEs, UPSERT, Sampling, and More

Java High-Performance Architecture

Apr 28, 2018 · Databases

Master MySQL 8 CTEs: Syntax, Benefits, and Real‑World Examples

This article introduces MySQL 8's Common Table Expressions (CTEs), explains their syntax and advantages over derived tables, and provides multiple practical examples—including recursive queries, table creation, and usage in INSERT, UPDATE, and DELETE statements—plus a Docker setup tip for MySQL 8.

CTECommon Table ExpressionsDocker

0 likes · 9 min read

Master MySQL 8 CTEs: Syntax, Benefits, and Real‑World Examples

ITPUB

Apr 27, 2018 · Databases

MySQL 8.0 Highlights: Invisible Indexes, Persistent Settings, UTF8MB4, CTEs, and Window Functions

This article walks through MySQL 8.0's key relational‑database enhancements, including invisible indexes for performance testing, the SET PERSIST command for persistent configuration, default utf8mb4 encoding, Common Table Expressions for clearer queries, and window functions for advanced ranking and aggregation.

8.0CTESQL

0 likes · 7 min read

MySQL 8.0 Highlights: Invisible Indexes, Persistent Settings, UTF8MB4, CTEs, and Window Functions

21CTO

Mar 14, 2018 · Databases

Unlock Faster Queries: Master Window Functions and CTEs in MySQL & MariaDB

Both MySQL 8 and MariaDB 10.2 introduce robust window functions and Common Table Expressions (CTEs), enabling developers to write more efficient, maintainable queries; this article explains their syntax, demonstrates practical examples, compares implementations, and highlights performance and readability benefits across popular database systems.

CTEMariaDBSQL

0 likes · 13 min read

Unlock Faster Queries: Master Window Functions and CTEs in MySQL & MariaDB

ITPUB

Jul 8, 2017 · Databases

How I Cut a 35‑Second SQL Query to Under 2 Seconds with Indexes and CTE Refactoring

A slow SQL Server query that took 35 seconds to load 4,000 rows was dramatically accelerated by analyzing the execution plan, adding targeted non‑clustered indexes, eliminating costly scalar functions, and rewriting the query with CTEs and FOR XML PATH, ultimately achieving a ten‑fold speedup.

CTESQL Server

0 likes · 11 min read

How I Cut a 35‑Second SQL Query to Under 2 Seconds with Indexes and CTE Refactoring

Qunar Tech Salon

Jun 18, 2017 · Databases

Understanding and Applying Common Table Expressions (CTE) in SQL

This article introduces Common Table Expressions (CTE) in SQL, explains how they improve query readability and enable writable temporary tables, demonstrates multi‑table modifications, advanced CRUD scenarios, implements a ring‑buffer using CTE, and discusses performance benefits and potential pitfalls.

CTERing BufferSQL

0 likes · 12 min read

Understanding and Applying Common Table Expressions (CTE) in SQL

ITPUB

Feb 17, 2017 · Databases

How to Speed Up SQL Server Paging with ROW_NUMBER, FORCESEEK and Hash Joins

This article explains why a SQL Server paging query using TOP can take minutes, demonstrates how switching to ROW_NUMBER() with CTEs, index hints, temporary tables, and hash joins dramatically reduces execution time, and provides practical tips for handling large page numbers.

CTEHash JoinIndex Hint

0 likes · 16 min read

How to Speed Up SQL Server Paging with ROW_NUMBER, FORCESEEK and Hash Joins

dbaplus Community

Dec 14, 2016 · Databases

How I Cut a 2.5‑Second SQL Query to 1.8 Seconds: A Deep Dive into View‑Based Performance Fixes

This article walks through a real‑world MySQL performance case where a complex view caused slow queries, explains step‑by‑step analysis, shows how redundant joins and Cartesian products were eliminated with CTEs and EXISTS, and demonstrates how the execution time dropped from 2.5 s to 1.8 s.

CTEPerformance OptimizationSQL

0 likes · 10 min read

How I Cut a 2.5‑Second SQL Query to 1.8 Seconds: A Deep Dive into View‑Based Performance Fixes

ITPUB

Jul 6, 2016 · Databases

Why CTEs Can Kill SSIS Performance and How to Fix It

A developer encountered severe slowdown when joining a remote server query via a CTE in SSIS, analyzed the underlying CTE and Nested Loops behavior, and resolved the issue by materializing the remote data into a temporary table, achieving a dramatic performance boost.

CTESQL ServerSSIS

0 likes · 7 min read

Why CTEs Can Kill SSIS Performance and How to Fix It

dbaplus Community

Feb 3, 2016 · Databases

What Makes PostgreSQL Superior? Data Types, Indexes, and Queries Compared

This article examines why PostgreSQL claims to be the most advanced open‑source database by detailing its object‑relational model, extensive native data types, large‑scale size limits, robust ACID compliance, powerful indexing options, flexible virtual table features, built‑in functions, language extensions, and how these capabilities compare to MySQL, MariaDB and Firebird.

CTEData TypesJSON

0 likes · 21 min read

What Makes PostgreSQL Superior? Data Types, Indexes, and Queries Compared

ITPUB

Jan 1, 2016 · Databases

10 Essential PostgreSQL Tips to Boost Your Productivity

Discover ten practical PostgreSQL techniques—including CTEs, custom .psqlrc settings, pg_stat_statements, FDWs, array handling, materialized views, window functions, pivot shortcuts, PostGIS, and JSONB—to write cleaner queries, improve performance, and leverage advanced database features.

CTEFDWJSONB

0 likes · 9 min read

10 Essential PostgreSQL Tips to Boost Your Productivity