Documenting rule-of-thumb when optimizing DB usage with indexes, with caveats