Search

Optimization

All articles tagged with "Optimization"

3 Total Articles

Database Indexing Explained

Database indexes use B-tree structures maintaining sorted pointers to rows. Like book indexes, they enable fast lookups without scanning entire tables.

Constraints That Govern Systems

Theory of Constraints: Identify the bottleneck limiting system performance. Optimizing non-constraints wastes effort without improving throughput.