Basic question on RAID array / Tablespace configuration.

Have an approx 50 GB database (that is data+indexes) that will be used for aggregation queries and other OLAP type of stuff. E.g. write performance next to irrelevant, massive sequential reads from index and tables, I guess not a whole lot of probe-type random reads. Beware some of the queries do heavy writes to TEMP space.

Hardware available is 8 80GB drives. Loss of data in the event of a drive loss is of very little concern.

Thoughts?:

-> Stripe (RAID0) all 8 drives, then logically partition into Data, Index,
Temp, etc.
-> Stripe (RAID0) 3 drives for Data, 3drives for Index, 2 for Temp. E.g.
ensure that index and data are on separate physical devices.
-> Any better configurations?

Thanks,
TR. Received on Sat Jun 22 2002 - 09:03:46 CDT