What is the most efficient way to lookup an object (e.g. a user) by only a string?
My answer to What is the most efficient way to lookup an object (e.g. a user) by only a string? on Quora
Yes—an index on a varchar column is exactly how you would implement this.