Rebeauty Atlas는 무엇인가요?

Rebeauty Atlas는 AI·디자인·마케팅·경제·의료 등 다양한 주제의 Medium 아티클을 수집해 태그·트랙·위키·인사이트로 탐색할 수 있게 정리한 리서치 아카이브입니다.

글은 어떻게 모이나요?

Rebeauty Atlas는 Medium에 공개된 아티클을 자동 수집해 AI·디자인·마케팅·경제·의료 등 주제별 태그·트랙·위키로 정리하는 리서치 아카이브입니다.

사이트는 어떤 섹션으로 구성되어 있나요?

Articles · Wiki · Insights · Tags 섹션으로 구성되어 있으며, PHP MVC · MySQL · shadcn-style UI · Wiki via keyword rules 로 만들어졌습니다.

Articles · Rebeauty Atlas

TCH

SA Satadru · Data Engineer Things

Join Order Matters! Understanding how Modern Query Optimizers Think

Okay, I could have started this blog with a question: “Does the order of tables in a SQL JOIN matter?”

Jul 10, 2026 · 6 min read · 28 claps #query-optimization #snowflake #data-engineering

Join Order Matters! Understanding how Modern Query Optimizers Think

SCI TCH

JU Jubin Soni · CodeToDeploy

Apache Spark Query Optimization on Databricks: Catalyst, AQE, and Photon Engine

A deep dive into how Spark transforms your SQL into a physical execution plan — and how Databricks layers Adaptive Query Execution and the…

Jun 26, 2026 · 9 min read · 50 claps #apache-spark #query-optimization #photon

Apache Spark Query Optimization on Databricks: Catalyst, AQE, and Photon Engine

MU Murat Culum

PostgreSQL Alt Sorgular (Subqueries) / Part 8

Giriş

Jun 17, 2026 · 3 min read · 0 claps #postgresql #subquery #query-optimization

PostgreSQL Alt Sorgular (Subqueries) / Part 8

TCH

SA Satadru · Data Engineer Things

If AQE can create Broadcast Joins Automatically, why do we still need Broadcast Hints?

Before we dive into today’s topic, I highly recommend checking out my previous blogs on Spark Join internals if you haven’t already—

Jun 15, 2026 · 8 min read · 1 claps #pyspark #databricks #data-engineering

If AQE can create Broadcast Joins Automatically, why do we still need Broadcast Hints?

TCH LIF

SA Satadru · Data Engineer Things

Join Optimization in Snowflake: The Power of Bloom Filters

No matter whether we are working with Snowflake, Databricks or any other platform, we love visibility into query execution! And there comes…

Jun 05, 2026 · 5 min read · 14 claps #snowflake #data-engineering #cloud-computing

Join Optimization in Snowflake: The Power of Bloom Filters

TCH HUM

ER Eric Sun

The Join-Aware Materialized View Query Rewrite Gap

Why Star Schema Breaks Most Cloud Warehouses? A look at why join-containing materialized views with transparent query rewrite are the rule…

Jun 04, 2026 · 4 min read · 0 claps #materializedviews #query-optimization #semantics

The Join-Aware Materialized View Query Rewrite Gap

TH Thao Luu

Why limit 10 is sometimes slow in Distributed SQL Engines?

When moving from traditional databases to distributed ones — in my case, the Hive database — I used to assume this query:

May 31, 2026 · 2 min read · 0 claps #sql #hadoop #hive

Why limit 10 is sometimes slow in Distributed SQL Engines?

AI

RA Rahul Sharma

Can an LLM optimize your MongoDB queries? I tried it — here’s what actually worked

LLMs are great at rewriting code. So can one look at a slow MongoDB aggregation pipeline and rewrite it into a faster, equivalent one? I…

May 30, 2026 · 4 min read · 0 claps #mongodb #database #query-optimization

Can an LLM optimize your MongoDB queries? I tried it — here’s what actually worked

TCH

VI Vineet Sharma

EF Core & Database - .NET Code Review Mastery Series

N+1 Queries, AsNoTracking, Projections, Transactions, Indexes, Connection Leaks, and MongoDB Optimizations

May 29, 2026 · 12 min read · 1 claps paywalled #net10 #mongodb #bulk-operation

EF Core & Database - .NET Code Review Mastery Series

GR Greptime

From 29s to 0.21s: Pushing TopK Bounds Down to the Scan Layer in GreptimeDB

How GreptimeDB took ORDER BY end_time DESC LIMIT 10 from ~29s to sub-second by pushing the runtime TopK bound down to the Mito scan layer.

May 27, 2026 · 9 min read · 0 claps #performance #database #data-fusion

From 29s to 0.21s: Pushing TopK Bounds Down to the Scan Layer in GreptimeDB

AI TCH

PR PRATEEK SINGH

samkhya v1.0: Plug Claude, GPT-4o-mini, or Local Ollama Into Your SQL Query Optimizer

An open-source Rust SDK that lets a foundation model like Claude, GPT-4o-mini, or Local Ollama help estimate row counts in DataFusion…

May 25, 2026 · 13 min read · 5 claps #rust #openai #claude-code

samkhya v1.0: Plug Claude, GPT-4o-mini, or Local Ollama Into Your SQL Query Optimizer

TCH MKT

PR Prakriti Juneja

Data Warehouse Modernization for Faster Enterprise Reporting

Data Warehouse Modernization has become a critical priority for organizations managing expanding analytics workloads, AI initiatives, cloud…

May 20, 2026 · 6 min read · 0 claps #data-warehouse #cloud-data-warehouse #analytics-workloads

TO Tofayel Hyder Abhi

Cursor-Based Pagination Without COUNT: The Fetch n+1 Pattern

A tiny trick that eliminates a COUNT query and makes cursor-based pagination feel effortless.

May 18, 2026 · 3 min read · 0 claps #cursor-based-pagination #pagination #query-optimization

Cursor-Based Pagination Without COUNT: The Fetch n+1 Pattern

TCH

NU nunacode · Webmaster Nexus

Why Your Queries Are Slow

How Execution Plans Will Fix Them

May 16, 2026 · 4 min read · 0 claps #database-performance #query-optimization #sql

TCH

PR Preethi Kaluva · Towards Data Engineering

SQL Boo-Boos #3: Why My Row Count Doubled After a Join (And Why That’s Way More Dangerous Than You…

Let me paint a picture.

May 16, 2026 · 6 min read · 0 claps #sql #join #data-modeling

SQL Boo-Boos #3: Why My Row Count Doubled After a Join
(And Why That’s Way More Dangerous Than You…

TH The Latency Gambler

I Read a 5-Page SQL Optimization Paper So You Don’t Have To

10 tips. Measurable results. Zero fluff.

May 10, 2026 · 4 min read · 282 claps paywalled #sql #query-optimization #research-paper

I Read a 5-Page SQL Optimization Paper So You Don’t Have To

TCH MKT

RO Rose Caleno

My Look Won’t Load: Making Sense of Looker’s Slowest and Heaviest Queries and How to Fix Them

How to understand the SQL that Looker explores generate so that you can fix what is actually broken.

Mar 25, 2026 · 6 min read · 5 claps #looker #lookml #data-analytics

My Look Won’t Load: Making Sense of Looker’s Slowest and Heaviest Queries and How to Fix Them

KE keylearn · Dev Genius

Understanding Database Indexes: A Visual, Hands-On Guide

How full scans, B-Trees, range searches, and composite indexes actually work — with real examples

Mar 17, 2026 · 7 min read · 7 claps paywalled #b-tree #database #software-engineering

Understanding Database Indexes: A Visual, Hands-On Guide

AI

DE DevOZ

쿼리 최적화 및 변환 — Query Optimization

이전 글에서는 하이브리드 서치(Hybrid Search)로 찾아낸 문서들의 순위를 정밀하게 다시 매기는 깐깐한 문지기, 리랭커(Reranker)에 대해 알아보았습니다.

Mar 15, 2026 · 4 min read · 0 claps #rags #query-optimization

WI Wilson Cavalcante

Understanding AEM Index Naming and Versioning (Best Practices for AEM Cloud)

How AEM index naming works, how custom index versions evolve, and why proper versioning is essential for safe deployments in AEM as a Cloud

Mar 10, 2026 · 4 min read · 0 claps #query-optimization #indexing #adobe-aem

Understanding AEM Index Naming and Versioning (Best Practices for AEM Cloud)

TCH

SA Sauman Arshad

Indexes Aren’t Magic: Understanding What Actually Happens When You Query

You fixed your schema. You’ve got foreign keys, constraints, perfect normalization. Then you deploy and… queries that should be instant…

Jan 27, 2026 · 5 min read · 0 claps #indexes-in-sql #relational-databases #query-optimization

Indexes Aren’t Magic: Understanding What Actually Happens When You Query

ART TCH AI

TH The Data Forge

🧱How Columnar Storage Actually Works

Parquet, ORC, Arrow — Internal Anatomy Explained (No Hand-Waving)

Dec 31, 2025 · 7 min read · 1 claps paywalled #data-engineering #columnar-storage #lakehouse-architecture

MO Mobin Shaterian · DataDrivenInvestor

Integrating SQLC and GraphQL in Go: A Practical Example with Product Filtering

GraphQL provides a powerful query language for clients, while SQLC generates type‑safe Go code directly from SQL queries

Dec 30, 2025 · 3 min read · 0 claps #graphql #golang-tutorial #sqlc

Integrating SQLC and GraphQL in Go: A Practical Example with Product Filtering

TCH

RU Rui Carvalho · Learning SQL

Stop Using INNER JOIN When You Only Need A Filter

How SEMI JOIN keeps Spark queries simpler, lighter and cheaper to run

Dec 04, 2025 · 5 min read · 75 claps paywalled #data-engineering #apache-spark #sql

Stop Using INNER JOIN When You Only Need A Filter

TCH

CH ChokSheak Lau

[React+TypeScript] Cracking the Code of Data Fetching with Persistent Caching

Introduction

Nov 30, 2025 · 14 min read · 0 claps #react #query-optimization #react-query

AI

FE Ferenc Bodon, PhD · KX Systems

Benchmarking KDB-X vs QuestDB, ClickHouse, TimescaleDB and InfluxDB with TSBS

Key Takeaways

Nov 26, 2025 · 6 min read · 1 claps #benchmarking #kdb-x #performance

Benchmarking KDB-X vs QuestDB, ClickHouse, TimescaleDB and InfluxDB with TSBS

HUM ECO TCH

RA Raja Ravi Varman

Optimizing Performance of Queries with LINQ in C#

LINQ (Language Integrated Query) has revolutionized how C# developers work with data, providing an elegant and readable syntax for querying…

Nov 20, 2025 · 4 min read · 6 claps paywalled #c-sharp-programming #linq #query-optimization

TCH LIF AI

NE Neurobyte

Vectorized Execution 101

How DuckDB squeezes warehouse-class speed out of a single machine using columns, batches, and a ruthless focus on CPU efficiency.

Sep 22, 2025 · 5 min read · 0 claps paywalled #duckdb #vectorized-execution #data-engineering

PA Patnamsanjeevi

SQL Indexes For Beginners

We always wonder whenever SQL table size increases we see that the SELECT query that we always use to fetch records will take time in…

Aug 31, 2025 · 3 min read · 0 claps #database-indexing #sql-index #sql-performance

ART

HS Hüsnü Hamurcu

Veri Tabanı Yönetiminin Temelleri: SQL’de DQL Komutları

Bir önceki paylaşımımda Veri Tabanı Yönetiminin Temelleri konusuna giriş yapmıştım ve şimdi kaldığım yerden devam ediyorum. Bu paylaşımın…

Aug 24, 2025 · 5 min read · 0 claps #sql #dql #query-optimization

MDA

SH Shreyans Padmani

Indexing In SQL

An index in SQL is similar to an index in a book. Instead of scanning the entire table (like reading every page), the database uses the…

Jul 18, 2025 · 2 min read · 0 claps #sql-index #database-indexing #indexing

LIF TCH

RA Ravindu Hirimuthugoda · Javarevisited

🚀 Supercharge Your Spring Data JPA Queries with Query Hints: A Practical Guide with Performance…

In today’s data-driven applications, performance optimization isn’t just a nice-to-have — it’s a must. As developers, we often focus on…

Jul 13, 2025 · 3 min read · 939 claps #spring-data-jpa #query-optimization #hibernatetips

🚀 Supercharge Your Spring Data JPA Queries with Query Hints: A Practical Guide with Performance…

ECO SPT

RO Rohat Şahin

Some Tips for Resolving SQL Query Performance Anomalies

In this post, I will discuss how to determine whether our SQL queries are running efficiently. Performance issues with queries are common…

Jun 01, 2025 · 5 min read · 2 claps #postgresql #query-optimization #database-management

Some Tips for Resolving SQL Query Performance Anomalies

TCH

SH Shyam Rao · DBSQL SME Engineering

Databricks SQL: Intelligent Performance, Automatically

Overview

Apr 17, 2025 · 4 min read · 4 claps #databricks-sql #predictive-optimization #liquid-clustering

ECO

SO Soner Oz

Query Optimization Techniques for High-Performance Oracle Databases

In today’s data-driven world, the efficiency of database queries plays a critical role in determining the performance of applications…

Dec 23, 2024 · 2 min read · 1 claps #oracle #query-optimization #sql-performance-tuning

Query Optimization Techniques for High-Performance Oracle Databases

MA Mango

PostgreSQL Explain의 유형별 실행계획 (1)

RDB 마다 서로 최적화 방법이 다르고 쿼리 실행계획을 표현하는 용어들이 다릅니다. 오늘은 이러한 RDB 중 OLTP 서비스에서 정말 많이 사용되는 DB 중 하나인 PostgreSQL 의 Explain 에 대해 알아보겠습니다.

Oct 06, 2024 · 8 min read · 0 claps #explain #rdb #postgresql

TCH

KA Karthiksatish

Why Knex.js is a Better Choice for SQL Queries and Database Migrations

Introduction

Sep 30, 2024 · 3 min read · 1 claps #knexjs #nodejs #owasp

TCH

NO Noelia Tardón

Demystifying Redshift Materialization

Smart Strategies for Efficient Data Scanning

Sep 29, 2024 · 11 min read · 52 claps #materialization #datascan #query-optimization

KR Krishna yogi

Spark AQE — A Detailed Guide with Examples

A Practical Guide for Spark AQE

Jul 29, 2024 · 6 min read · 9 claps #spark-aqe #aqe #query-optimization

Spark AQE — A Detailed Guide with Examples

ECO

SR Sradha Jana

Resolving a unique real-time use-case with cross join and unnest to get the common data from…

We all know the trivial definition of cross join, its helps to achieve cartesian product of two tables. In its simplest form an example of…

Oct 07, 2023 · 2 min read · 0 claps #postgresql #plpgsql #unnest

Resolving a unique real-time use-case with cross join and unnest to get the common data from…

KE keylearn

PostgreSQL Hash Table Partition

This story is a part of PostgreSQL Table Partition. Let’s talk about hash partition in this section. Hash partition is kind of a horizontal…

Jan 25, 2023 · 1 min read · 1 claps paywalled #hash-partition #postgresql #table-partitioning

KE keylearn

PostgreSQL Range Table Partition

This story is a part of PostgreSQL Table Partition. The story tells more information about range partition with example. Range partition is…

Jan 18, 2023 · 2 min read · 2 claps paywalled #postgres #partitioning #range-partition

TCH

HA Harshit Yadav

What is Result Set in Database?

Overview

Jun 13, 2022 · 5 min read · 42 claps #resultset #database #database-design

AN Andrey Minogin

A hint on PostgreSQL ranking query optimization

Recently I’ve stumbled upon a few similar cases of ineffective queries which I want to share with you.

Jun 07, 2020 · 1 min read · 4 claps #sql #postgresql #query-optimization