RE: ** re-insert data in primary key order

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of A Joshi Sent: Monday, October 10, 2005 2:49 PM
To: oracle-l_at_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

Yahoo! Music Unlimited - Access over 1 million songs. Try it free. <http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yah oo.com/unlimited/>

--
http://www.freelists.org/webpage/oracle-l