Re:Squeeze the hell out of the system you have
by unnouinceput on Saturday August 12, 2023 @06:55AM
(#37098893)
If you use a varchar as FK then you're definitely doing something wrong from beginning. OP was talking about getting the phone number under certain conditions, and a phone number column is a varchar.
[ Parent
| on HN ]
Re:Squeeze the hell out of the system you have
by aidos on Saturday August 12, 2023 @07:10AM
(#37098975)
I don’t think they ever did a lookup on phone number and even if you needed to, you would just index it and it’d be fast. You can even use things like tri-gram indexes to give you super fast partial phone number matching.