“People can have the Model T in any color – so long as it's black.”
- Henry Ford
Creating a Unique Secondary Index (USI)
We created a Unique Secondary Index (USI) on the column Emp_No named idxname.
What is in a Unique Secondary Index (USI) Subtable?
Inside the secondary index subtable is the column Emp_No (USI Column). Then, there is the corresponding Row-ID of the real Primary Index of the table. The USI subtable's Primary Index is Emp_No, and it is hashed and has a Row-ID like a normal table.
A Unique Secondary ...