Try as I might, I cannot get the "generated" column on user/all/dba _ indexes
to take on any value other than 'N'.
I thought it was set to 'Y' if the index was system created, and indeed, that's
what the docs state. However, I have run a few tests creating pk and unique
constraints, without pre creating the supporting index, and the value remains
stubbornly set to 'N'.
Ditto when the creation of an MVIEW crews a new primary key, the underlying
index still flags as not system generated.
I admit to being puzzled! Can someone please enlighten me? Thanks.
Cheers,
Norm.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.