The SYSIDX system view has a column "unique" that classifies the logical index as follows:
What does a value of 5 mean? An unique index with the new "CREATE INDEX ... WITH NULLS NOT DISTINCT" clause?
(At least that seems to be the case in my tests...)
You are correct. The values are:
I will make sure that the documentation is modified appropriately. Thanks for reporting the oversight.
answered 22 May '12, 17:29