We are working on some integrations with third-party vendors regarding Shipping updates and found that the Track Number in the database, is setup as a Text rather than a Varchar. So we cannot optimize lookups, by adding an index on the table for that field.
Is there a reason for making it a Text at 64k vs. a Varchar 255? I am not seeing anything in the code, but then again I am not sure what I am looking for exactly.
We are toying with the idea of updating the Track Number and making it a Varchar 255 and indexing it, but don't want to just change it with out being certain there was not a reason.
Help is appreciated.
