|location||Cape Town, South Africa|
|visits||member for||2 years, 5 months|
|seen||Dec 18 '14 at 9:37|
Comp Sci Honours Java Developer Freelance ASP.Net developer
Does having an index on a VARCHAR column with a lot of very similar starting values have bad performance
@Mark - The width is varchar(64) We can have up to 7 million rows. We run cleaners on it daily to remove old data. So about 7-10 million on average. I guess the average length of that field is about 20-30.