From oracle-l-bounce@freelists.org Wed Mar 31 06:36:22 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2VCaKN03510 for ; Wed, 31 Mar 2004 06:36:20 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2VCaKo03504 for ; Wed, 31 Mar 2004 06:36:20 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C97DA63488A; Wed, 31 Mar 2004 07:32:49 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26330-94; Wed, 31 Mar 2004 07:32:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1156863482B; Wed, 31 Mar 2004 07:32:49 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 31 Mar 2004 07:31:43 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 212B96347F5 for ; Wed, 31 Mar 2004 07:31:43 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26330-73 for ; Wed, 31 Mar 2004 07:31:43 -0500 (EST) Received: from gizmo04ps.bigpond.com (gizmo04ps.bigpond.com [144.140.71.14]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id C5E46634746 for ; Wed, 31 Mar 2004 07:31:41 -0500 (EST) Received: (qmail 4354 invoked from network); 31 Mar 2004 12:32:31 -0000 Received: from unknown (HELO psmam13.bigpond.com) (144.135.25.106) by gizmo04ps.bigpond.com with SMTP; 31 Mar 2004 12:32:31 -0000 Received: from cpe-203-51-35-77.nsw.bigpond.net.au ([203.51.35.77]) by psmam13.bigpond.com(MAM REL_3_4_2 237/14330054) with SMTP id 14330054; Wed, 31 Mar 2004 22:39:54 +1000 Message-ID: <0ebf01c4171d$d6467a50$0100000a@FOOTE> From: "Richard Foote" To: References: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFC6F@bosmail00.bos.il.pqe> Subject: Re: pros and cons Date: Wed, 31 Mar 2004 22:43:58 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2727.1300 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2162 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: richard.foote@bigpond.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi Mark, The index doesn't have to be dropped if you use the KEEP INDEX option (9i). Cheers Richard From: "Bobak, Mark" To: Sent: Wednesday, March 31, 2004 10:41 AM Subject: RE: pros and cons No gotchas that I'm aware of. I look at it as an adavantage, because when you're doing table maintenance, you can disable the PK/UK constraint, and the corresponding index won't be dropped. In the case of a unique index, any time you diable the corresponding constraint, the index will be dropped. (It has to be, else the column would still have the unique property, due to the index.) ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------