I've successfully created a clustered index on Microsoft SQL server, but I'm not sure how to do this with Oracle as I don't usually have to work with Oracle.
On MSSQL I write
create CLUSTERED index [MyIndex] on MyTable (datestamp)
The need a clustered index so that I can force the physical order of the table. I'm adding log data to a table and basically want it sorted by the date.
If one could post the SQL syntax here and I would be very grateful.