From oracle-l-bounce@freelists.org Tue Oct 11 11:24:38 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9BGOcl5013881 for ; Tue, 11 Oct 2005 11:24:38 -0500 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 j9BGOavX013871 for ; Tue, 11 Oct 2005 11:24:36 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 499831FBCB8; Tue, 11 Oct 2005 11:24:32 -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 13090-04; Tue, 11 Oct 2005 11:24:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BC0D81FBBA5; Tue, 11 Oct 2005 11:24:31 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=F2Fv4kPHU73qPvbfKlmB8gnNt9U5AeQDABahJK4zsM3eifVdSWlX3EP/pgeRp8goXOUpi46PwXGGLu+XM8l0ZTNBoZKnWEbelw7w0g9FkfG++DwHFKjZKWff0I/Z0bKKgft3K/nyfgGA/EDD9JCUCHffK3QjjKXXxIjPh8K3fu8= ; Message-ID: <20051011162230.74897.qmail@web50103.mail.yahoo.com> Date: Tue, 11 Oct 2005 09:22:30 -0700 (PDT) From: Kirtikumar Deshpande Subject: Re: ** re-insert data in primary key order To: ajoshi977@yahoo.com, oracle-l@freelists.org In-Reply-To: <20051010214849.86040.qmail@web60718.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-archive-position: 26697 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kedeshpande@yahoo.com Precedence: normal Reply-To: kedeshpande@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.0 required=5.0 tests=AWL,BAYES_00, FORGED_YAHOO_RCVD autolearn=no version=2.63 If the PK index is used by majority of the queries, those will benefit. Yes, Oracle will know about the ordered data from the index clustering factor. I suggest referring to docs/notes that discuss index clustering factor (google search will help your there). Here is one link I like : http://www.dizwell.com/html/clustering_factor.html Cheers! -Kirti --- A Joshi wrote: > Hi, > I would like to know if delete and re-insert of table data in primary key order is of > help. And in what circumstances. Is there a way for Oracle to know or hint it that data > is in primary key order? Any related info? Thanks > > > --------------------------------- > Yahoo! Music Unlimited - Access over 1 million songs. Try it free. __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- http://www.freelists.org/webpage/oracle-l