Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: pros and cons
Hm, I started testing, and it seems that I was wrong in my previous post..
I did some testing on 9.2. and yes, whether the index gets dropped, is
dependent on its uniqueness, not the generated flag...
Sorry for the confusion...
Tanel.
> > By the way, whether the index is dropped or not upon PK/UK constraint
> > disabling, is dependent on whether the index is system generated or not
> > (the generated column on dba_indexes). You can have an unique index used
used
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Apr 01 2004 - 03:20:44 CST
![]() |
![]() |