Guides ยท Technology
Database Indexing Basics
Speed up queries
Indexing adds data structures that speed WHERE, JOIN, and ORDER BY queries at the cost of write overhead and space; choose keys carefully.
- b-tree
- covering index
- selectivity
- composite
- analyze
Pick Columns
Index columns with high selectivity used in filters and joins.
Design Keys
Use composite indexes in filter order; avoid redundant indexes.
Maintain
Monitor bloat and writes; drop unused indexes.
Keep Exploring
Guides
API Basics
APIs let software request data or actions from other systems through defined endpoints and responses.
Comparison
RAM vs Storage
RAM handles what your device is actively working on, while storage keeps apps, files, and system data available over time.
How it works
Global Positioning System
GPS uses timing signals from satellites to calculate a receiver's position on Earth.
What it is
Blockchain
A blockchain is a distributed ledger secured by cryptography and consensus nodes.