From oracle-l-bounce@freelists.org Fri Jan 28 05:16:08 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0SBG6gD026603 for ; Fri, 28 Jan 2005 05:16:06 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0SBG4em026597 for ; Fri, 28 Jan 2005 05:16:05 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6E47E673D6; Fri, 28 Jan 2005 05:15:15 -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 04248-06; Fri, 28 Jan 2005 05:15:15 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E7464673BE; Fri, 28 Jan 2005 05:15:14 -0500 (EST) Message-ID: <41FA1056.4020606@iinet.net.au> Date: Fri, 28 Jan 2005 21:13:42 +1100 From: Nuno Souto User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: oracle-l@freelists.org Subject: Re: Referential indexes References: <1831A554E8800049B6B970790D2513C001C360E1@fnbkrkmx01.fnb.co.za> In-Reply-To: <1831A554E8800049B6B970790D2513C001C360E1@fnbkrkmx01.fnb.co.za> Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 15399 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dbvision@iinet.net.au Precedence: normal Reply-To: dbvision@iinet.net.au X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at example.com X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: Leonard, George apparently said,on my timestamp of 28/01/2005 8:51 PM: > Got this query from a developer, or actually they are actually arguing > with the DBA team. > > Table A - master, acc number field also only column in PK > > Table B - Child, acc Number Field acc number is the first > column in PK, PK contains 2 more columns. > > DBA's are saying we don't need a normal non unique stand alone index on > the acc Number field for table B. > > Developers want a separate index, > > COMMENT? > Developers are wrong. -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@iinet.net.au -- http://www.freelists.org/webpage/oracle-l