Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> constraints and indexes

constraints and indexes

From: Chris Stephens <cstephens16_at_gmail.com>
Date: Thu, 9 Jun 2005 10:47:12 -0400
Message-ID: <d95e86070506090747316d5b46@mail.gmail.com>


I've discovered an odd different between our testing and staging environments here that I am unable to explain/duplicate. It probalby exemplifies my lack of understanding of indexes and constraints.

We have the exact same table in both environments with the exact same primary key constraint and supporting index. In one database when i disable the constraint, the corresponding index is dropped. In the other when i disable the constraint, the corresponding index remains.=20 Any idea what the difference is?

I thought it might have to do with creating the index first as opposed to just creating the constraint and implicitly creating the index but that doesn't seem to be the case.

I'm off to read the series of articles Jonathan Lewis wrote for dbazine on constraints but thought i'd post this first. (probably the wrong order but whatever).

Thanks for any insight.
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 09 2005 - 10:52:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US