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...) asked 22 May '12, 07:58 Volker Barth |
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 Glenn Paulley I may be hairsplitting but for the docs, I guess the description for values 1 and 5 should be worded differently as both are for unique indizes, such as:
(Apparently, that would only make sense for v12 and above...)
(23 May '12, 03:21)
Volker Barth
|