I have left the question of indices out for the time being; albeit, I recognize that the answer to this question may be based on the separate issue of what the indices look like.
My question is: without having to introduce a 5th column, is it possible to create a partitioning strategy for the above table that is based on the last 2 digits of the SSN column ?
Or does one have to have an additional CHAR(2) column (or something similar) that is maintained and which houses the last 2 digits of the SSN?
I ask the question independant of whether it is a pre-Version-8 "index-controlled" partition, or a Verson-8 and beyond "table-controlled" partition; although I recognize that the type of partition will probably be included in the answer. thank-you in advance to anyone who can provide an answer.