Dec 5, 2025 · 5 min read · 我們很常聽到索引(Index)，大部分工程師也都知道 RDBMS最基本的加速方式就是加上Index，但Index是個雙面刃，加的不好反而會嚴重拖累DB的速度，我們這個章節就來探討，Index的概念以及實務上的用法吧！ 為什麼我們需要索引？ 想像一本厚達 1,000 頁的字典。 沒有索引 (Full Table Scan)： 如果你想查「Apple」這個字，卻沒有目錄也沒有頁碼順序，你必須從第一頁翻到最後一頁，直到找到為止。這在資料庫中叫做 全表掃描 (Full Table Scan)，是效能殺...
Join discussionJul 5, 2025 · 15 min read · Welcome to the third part of our DBMS blog series! In this section, we’ll delve into more advanced and performance-critical concepts that form the backbone of modern database systems. From Indexes that speed up data retrieval to Concurrency Control t...
Join discussion
Jun 26, 2025 · 7 min read · As developers, we often focus on writing clean code and building features, but database performance optimization is equally crucial. Today, I'll share my deep dive into composite indexes - a powerful technique that can transform your query performanc...
Join discussion