Hello,
I have a database that has some large tables in it that I need to partition for performance and backup reasons. The largest of the tables has a 50GB data size and a 100GB index size. The only column I would be able to use as the partitioning key is a varchar(20) column. It contains a string of 10 numbers that range from 0000000000 to 0012000000. My question is, how are the left or right boundaries determined when you use a varchar column as the partitioning key?
Thanks for reading!