query-execution
Query Execution - Aggregations
How database engines execute sorting, hashing, grouping, and aggregation operations efficiently when data exceeds available memory.
Read article#hashing
2 articles
hashing-schemes
Understanding hash indexes
How database hash indexes avoid linear scans, organize buckets, handle collisions, and support efficient equality lookups.
Read article