🪴ttuan's garden
Search
Search
Dark mode
Light mode
Explorer
Tag: database
55 items with this tag.
Sep 07, 2026
Chọn kiểu lưu trữ
system-design
database
Sep 07, 2026
Database Index
system-design
database
performance
Sep 07, 2026
SQL vs NoSQL
system-design
database
core
Sep 07, 2026
Sharding
system-design
database
scaling
Sep 07, 2026
00 - MOC - Database Indexing
MOC
database
indexing
Sep 07, 2026
B+ Tree
database
indexing
foundation
Sep 07, 2026
Biến Range thành Equality
database
indexing
advanced
technique
Sep 07, 2026
CTE
database
sql-technique
Sep 07, 2026
Column Transformation
database
indexing
pitfall
Sep 07, 2026
Composite Index và Nguyên tắc Phễu
database
indexing
principle
composite-index
Sep 07, 2026
Có Index chưa chắc Query nhanh
database
indexing
foundation
misconception
Sep 07, 2026
Database Constraint
database
schema-design
constraint
Sep 07, 2026
Denormalization
database
schema-design
join
performance
Sep 07, 2026
EXPLAIN
database
optimizer
tool
Sep 07, 2026
Fast Lookup
database
indexing
principle
Sep 07, 2026
Functional Index
database
indexing
advanced
Sep 07, 2026
GROUP BY và DISTINCT
database
indexing
sql-operation
Sep 07, 2026
Ghost Condition
database
indexing
advanced
technique
Sep 07, 2026
Heap Table vs Clustered Index
database
indexing
foundation
storage
Sep 07, 2026
Index Selection - Xung đột Filter và Sort
database
optimizer
indexing
Sep 07, 2026
Index Write Overhead
database
indexing
foundation
trade-off
Sep 07, 2026
Index-Only Query và Covering Index
database
indexing
advanced
performance
Sep 07, 2026
Inequality và Index
database
indexing
sql-operation
pitfall
Sep 07, 2026
JSON Column
database
schema-design
json
Sep 07, 2026
JSON Indexing và GIN Index
database
indexing
json
advanced
Sep 07, 2026
Keyset Pagination
database
sql-technique
pagination
Sep 07, 2026
Kỹ thuật thao tác dữ liệu hiệu quả
database
sql-technique
data-manipulation
Sep 07, 2026
LIKE và Wildcard
database
indexing
sql-operation
Sep 07, 2026
Lateral Join
database
sql-operation
join
advanced
Sep 07, 2026
Low-Cardinality Column và Index
database
indexing
pitfall
Sep 07, 2026
Materialized Path
database
schema-design
tree
Sep 07, 2026
NULL và Index
database
sql-operation
pitfall
Sep 07, 2026
Nested Loop Join
database
indexing
sql-operation
join
Sep 07, 2026
ORDER BY và Index
database
indexing
sql-operation
Sep 07, 2026
Partial Index
database
indexing
advanced
postgresql
Sep 07, 2026
Partitioning
database
schema-design
maintenance
Sep 07, 2026
Pre-sort và Pre-aggregation
database
schema-design
performance
Sep 07, 2026
Prefix Index và Hash Index
database
indexing
advanced
Sep 07, 2026
Primary Key và thứ tự Insert
database
indexing
foundation
schema-design
Sep 07, 2026
Query Optimizer và Cost Model
database
optimizer
foundation
Sep 07, 2026
Query Tips hữu ích
database
sql-technique
tips
Sep 07, 2026
Quét một hướng
database
indexing
principle
Sep 07, 2026
Random IO vs Sequential IO
database
indexing
foundation
Sep 07, 2026
Range Condition phá vỡ Phễu
database
indexing
principle
composite-index
Sep 07, 2026
SQL Execution Order
database
sql
foundation
Sep 07, 2026
Spatial Index
database
indexing
advanced
geospatial
Sep 07, 2026
Statistics và ANALYZE
database
optimizer
Sep 07, 2026
Subquery
database
sql-operation
Sep 07, 2026
Trigram Index
database
indexing
postgresql
full-text-search
Sep 07, 2026
Type Mismatch và Implicit Cast
database
indexing
pitfall
mysql
Sep 07, 2026
UPDATE và DELETE cũng cần Index
database
indexing
sql-operation
Sep 07, 2026
UUID vs Auto-increment
database
schema-design
primary-key
Sep 07, 2026
Unique Constraint và NULL
database
constraint
pitfall
Sep 07, 2026
Unused Index
database
indexing
maintenance
Sep 07, 2026
Virtual Column
database
schema-design
indexing