R
richard thompson
Guest
So right you are. I mixed my examples. The first example was with two indexes that contained the same three fields as index components but in different order. The premise being that if one was unique, the other had to be unique also. The final example was a little closer to home where we have in our application design many situations where we have a index on (for example) ssn as unique then we define a second index, also unique, on ssn and some other field. In that example, the single element index on ssn insures it is unique and there by extrapolation, any other index that contains the ssn field as a component of the index, unique. Thanks so much for all who responded. It really help to get such high quality feedback when performing some level of sanity check on my advice/analysis. Richard
Continue reading...
Continue reading...