Re:How does database indexing work? (2008)
by dikei on Tuesday March 08, 2022 @11:11AM
(#30601529)
Unless your own benchmarks prove hash indexes to have major benefits for your queries, stick with the default B-tree index: you never know what queries you'll need in the future.
[ Parent
| on HN ]
That's a bit too YAGNI for me. You have a `users` table with an `tenant_id uuid not null` column. You aren't going to need uniqueness on it and you aren't going to need range operations on it it.
And..even if you did, you could re-index it.