Reputation
Next privilege 200 Rep.
See reduced ads
Badges
4
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Dec
4
awarded  Popular Question
Sep
24
awarded  Autobiographer
Aug
7
awarded  Editor
Aug
7
revised Does having an index on a VARCHAR column with a lot of very similar starting values have bad performance
added 4379 characters in body
Aug
7
awarded  Student
Aug
7
comment 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.
Aug
6
asked Does having an index on a VARCHAR column with a lot of very similar starting values have bad performance