From oracle-l-bounce@freelists.org Mon Jun 21 10:39:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5LFcZU22684 for ; Mon, 21 Jun 2004 10:38:45 -0500 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 i5LFcP622632 for ; Mon, 21 Jun 2004 10:38:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4B06272C3E3; Mon, 21 Jun 2004 10:22:14 -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 03717-23; Mon, 21 Jun 2004 10:22:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7FE3972C0A6; Mon, 21 Jun 2004 10:22:13 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 21 Jun 2004 10:20:51 -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 7C36F72C193 for ; Mon, 21 Jun 2004 10:20:51 -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 02826-47 for ; Mon, 21 Jun 2004 10:20:51 -0500 (EST) Received: from taro.utanet.at (taro.utanet.at [213.90.36.45]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1421972C1B1 for ; Mon, 21 Jun 2004 10:20:51 -0500 (EST) Received: from paris.utanet.at ([213.90.36.7]) by taro.utanet.at with esmtp (Exim 4.12) id 1BcQvp-0001Fe-00 for oracle-l@freelists.org; Mon, 21 Jun 2004 17:42:01 +0200 Received: from christmas.utanet.at ([213.90.36.16] helo=utanet.at) by paris.utanet.at with smtp (Exim 4.12) id 1BcQvo-0004v7-00 for oracle-l@freelists.org; Mon, 21 Jun 2004 17:42:00 +0200 Received: from 213.162.65.17 (proxying for 10.249.17.182) by pwebmail.utanet.at with HTTP; Mon, 21 Jun 2004 17:42:00 +0200 (CEST) Message-ID: <52883.213.162.65.17.1087832520.bloek@pwebmail.utanet.at> Date: Mon, 21 Jun 2004 17:42:00 +0200 (CEST) Subject: RE: Question about Append hint in Insert From: "jaromir nemec" To: In-Reply-To: References: <144301c45715$342c6170$3c02a8c0@JARAWIN> X-Priority: 3 X-Mailer: UTA-WebMail (version 1.2.7/SGG) MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3208 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jaromir@db-nemec.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi Lex, Thanks for the correction of my misinterpretation. Does it mean there are no other differences or things to keep in mind when deciding between unique and non-unique index to support unique constraint? Thanks Jaromir D.B.Nemec > one small correction: non-unique indexes do *not* allocate more space... ---------------------------------------------------------------- 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 -----------------------------------------------------------------