2 ms·
then again, indexes on VARCHAR() can only really be used for equality and start matches. Now I'm not saying it's impossible, but I have a feeling you're not li
by pilif 8y ago
then again, indexes on VARCHAR() can only really be used for equality and start matches.
Now I'm not saying it's impossible, but I have a feeling you're not likely going to do a lot of `where string_column =… ` or `where string_column like '…%'` where … is 192 characters in length.
If you need to do substring search or full text search, a traditional index won't help you anyways.
- chrismorgan 8y agoYeah, string primary keys are the only place I expect people to actually hit this, as seen in the django-celery case.