R
richard thompson
Guest
Members, thanks. This is what I suspected. If flagging the additional indexes as unique provides no value added then the overhead of validating the uniqueness of the index is simply wasted effort. If index A is set to be unique on field ssn then any other index that contains the field ssn as a component of the index is also unique. If there can only be one record with the ssn "123456789" then the index comprised of name, age, bloodtype, teaPreference, and ssn will also be unique. Asking OE to verify that ssn is unique and then asking it to validate that name + bloodtype + teaPreference + ssn is also unique is a waist of time. I see no value in flagging the second index as unique. Richard
Continue reading...
Continue reading...