Re: 40 Million rows?

Ken Leach wrote:

> I have the need to create a table in Oracle 7.3.4 for NT that will hold
> over 40 Million rows...
> I have never worked with a table so huge.. what suggestions do you
> have....

Well for starters drop all indexes on the table before loading and then recreate them using a large sort area size.

> Suggested hardware?

Not knowing your application it is hard to say but with heavy updates like this you probably want fast disk mirrored and stripped rather than using RAID 5. Does any believe in not using redundant disk anymore ?

More than one processor would allow for using the parrallel options.

> The current data will be given to me in a text file and I will have to
> populate the table somehow, I was thinking of writing a quick little
> delphi application for that. However I am more concerned with how to
> set up Oracle to accept such a HUGE table!?

I don't think using Delphi will come anywhere close to the speed of SQL*Loader using a parrallel load and the direct path.Well you you will need to get for sizing correct but this can be done using trial and error if you are feeling lazy.

Try and use bitmap indexes where possible - in many cases they create quicker and are smaller than normal indexes.

One last thing - Consider using the partitioning features of Oracle 8, although you will have to pay extra for this.

>
>
> From what I know of the data there are about 10 columns, and number or
> char's. The data will remain static just need to create views and do
> query's off it...
>
> ANY suggestions are welcome.
>
> -Ken Leach

--

Bobby Abraham                   email : bobby_at_cm.co.za
Computer Management       Fax   : +27 31 3325552
Durban, South Africa           Phone : +27 31 3325541