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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of A Joshi Sent: Monday, October 10, 2005 2:49 PM To: oracle-l@xxxxxxxxxxxxx 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/>