Two questions

Hi All -

I have two quick questions - our environment is Oracle 8.0.5 running on Solaris.

1. What would be the best way to optimize a table for inserts? Currently I've removed all indexes on the table & just accessing records based on ROWID. Are there any tricks like adjusting block size, etc., that could make inserts go faster?
2. Say that you have a data source that gives the day of the year in DDD form (e.g. today is day 348). A separate field gives the number of seconds since midnight of that daytIs there a quick way to transform these data into a Oracle DATE var?

TIA,
John de Freitas

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 14 1999 - 08:55:14 CST