Anoop,
I would assume from that that if it is a unique multi-column secondary index,
that NULLs in the same column across rows is acceptable, as long as the
combination of all the values that make up the index key are unique. So, NULL
is in essence treated like it were a value, though the
traf indexes can be created on nullable columns and they can contain null
values.
If it is a unique index, then only one null value can be inserted.
If it is a non-unique index, then multiple null values can be inserted.
both 'is null' and 'is not null' preds can be applied on index scans.
See
Hi, all,
I heard that database index cannot save null value, so if the predicate
contains 'is null' 'is not null', then the index will not be used. Is this true
for Trafodion as well?
thanks,
Ming