Luckily we have brains that expose this interface quite readily with intuition. Learn the logic, and the partial indexes, the foreign keys, etc..they all follow. Reason before RAM. It is often much faster to derive data than to store it, and look it up. This applies to CPUs and to our brains. Our brains have instruction cache, and often instructions are better use of memory than their final executed output.