on 2012 May 22 8:58 AM
The SYSIDX system view has a column "unique" that classifies the logical index as follows:
Indicates whether the index is a unique index (1), a non-unique index (4), or a unique constraint (2). A unique index prevents two rows in the indexed table from having the same values in the index columns
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...)
Request clarification before answering.
You are correct. The values are:
I will make sure that the documentation is modified appropriately. Thanks for reporting the oversight.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...)
User | Count |
---|---|
68 | |
33 | |
8 | |
8 | |
7 | |
7 | |
7 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.