From oracle-l-bounce@freelists.org Mon Oct 10 16:58:26 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9ALwPx1017783 for ; Mon, 10 Oct 2005 16:58:25 -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 j9ALwNvX017767 for ; Mon, 10 Oct 2005 16:58:23 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 032C91FA77F; Mon, 10 Oct 2005 16:58:20 -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 15313-05; Mon, 10 Oct 2005 16:58:19 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7AA641FA77E; Mon, 10 Oct 2005 16:58:19 -0500 (EST) x-mimeole: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5CDE5.728BE075" Subject: RE: ** re-insert data in primary key order Date: Mon, 10 Oct 2005 14:56:19 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ** re-insert data in primary key order Thread-Index: AcXN5H7vBdrL8ABRQOaiyVzDIVHVnwAANr0A From: "Kennedy, Jim" To: , X-OriginalArrivalTime: 10 Oct 2005 21:56:20.0721 (UTC) FILETIME=[72CD9E10:01C5CDE5] X-archive-position: 26665 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jim_kennedy@mentor.com Precedence: normal Reply-To: jim_kennedy@mentor.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=-4.5 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5CDE5.728BE075 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable You could create the table as an IOT (index orgainized table) and then the data is in primary key order. otherwise all bets are off and not really relevaant.) Jim ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of A Joshi Sent: Monday, October 10, 2005 2:49 PM To: oracle-l@freelists.org Subject: ** re-insert data in primary key order 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=20 ________________________________ Yahoo! Music Unlimited - Access over 1 million songs. Try it free. =20 ------_=_NextPart_001_01C5CDE5.728BE075 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

You could create the table as an IOT (index = orgainized=20 table) and then the data is in primary key order. otherwise all = bets are=20 off and not really relevaant.)

Jim

From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of A=20 Joshi
Sent: Monday, October 10, 2005 2:49 PM
To:=20 oracle-l@freelists.org
Subject: ** re-insert data in primary = key=20 order

Hi,

I would like to know if delete and re-insert of = table data in=20 primary key order is of help. And in what circumstances. Is there a way = for=20 Oracle to know or hint it that data is in primary key order? Any related = info? Thanks

Yahoo!=20 Music Unlimited - Access over 1 million songs. Try it = free. ------_=_NextPart_001_01C5CDE5.728BE075-- -- http://www.freelists.org/webpage/oracle-l