Which database optimization technique stores frequently accessed data in faster memory?
- Indexing
- Caching
- Partitioning
- Replication
Answer: Caching
Caching (Redis, Memcached) stores hot data in RAM for sub-millisecond access, reducing database load. Critical for high-traffic applications. Trade-offs: cache invalidation, consistency.