RE: Creating a sorted table

This is totally NOT accurate. Yes there are performance gains storing index data ordered. Perhaps great on range scans. Yes you can reorder tables and indexes. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot

RE: Creating a sorted table

Title: RE: Creating a sorted table That is version specific, but you can use an index hint to do this in older versions. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Messag

RE: Creating a sorted table

|| Subject: RE: Creating a sorted table || || || This is totally NOT accurate. || || Yes there are performance gains storing index data ordered. || Perhaps great || on range scans. Yes you can reorder tables and indexes. || || Walking on water and developing software from a || specification

OT (everybody has a bad day once in a while...)/ RE: Creating a sorted table

On 30 May 2001, at 8:10, Christopher Spence wrote: This is totally NOT accurate. http://www.amazon.com/exec/obidos/ASIN/B5BYQH ---excerpt--- Tales of the Arabian Nights Barbie and Ken Our Price: $99.99 This item will be

RE: Creating a sorted table

: Sent by: Fax to: root@fatcity.Subject: RE: Creating a sorted table

RE: Creating a sorted table

Title: RE: Creating a sorted table Hi infact creating the table as sorted data from another table works with oracle 8.1.6.3.0 as: create table agrs as select * from agreements order by agr_agreement_number desc; Is this OK?? Vijay -- From: Connor McDonald[SMTP:[EMAIL

Re: Creating a sorted table

Alternately on earlier versions where the order by can't be used, is to select from the table in indexed order using a hint... hth connor --- Regina Harter [EMAIL PROTECTED] wrote: Well, it won't work in all cases, but I have on occasion used as a shortcut: INSERT INTO ... SELECT DISTINCT

Re: Creating a sorted table

There is a very good reason for having data approximately in physical order - it can dramatically improve your buffer hit rates. IOT's are great for this, but if you're on an earlier version then the occasional job to pseudo-cluster the data can be a very good thing... Cheers Connor --- [EMAIL

Re: Creating a sorted table

Whyever would you want data inserted in order? There is no guarantee that Oracle will actually store the records in order, there is no performance gain, and you can always retrieve the records in order by using an order by statement -- if you really need ordered data, you could use a

RE: Creating a sorted table

Try insert ... select* from (select * from table_name order by column_name) Alex Hillman -Original Message- Sent: Friday, May 25, 2001 6:45 PM To: Multiple recipients of list ORACLE-L We have un-ordered data in a table that needs to be inserted into a transaction table in order of the

Re: Creating a sorted table

Well, it won't work in all cases, but I have on occasion used as a shortcut: INSERT INTO ... SELECT DISTINCT transaction_date, ... since the distinct will order it for you, beginning with the first item in the select. A more reliable way would be to use pl/sql, select the ordered data into a