Extent size

Hi,

I want to optimize my new database. I have 3 types of tables :
- with 1.000.000 Rows (a lot of insertion in one time)

• with 100.000 Rows (a lot of insertion in one time)
• with 10.000 Rows
• with 1.000 Rows

I created 3 tablespaces for these data :
- 128 K extent size for the first one

• 96 K extent size for the second one
• 64 K extent size for the third
• 8 K extent size for the last

and 2 tablespace for index, one for the big table and the other for small table

Is it good to work like this, is it too much or too small ? What's the best solution for storage, in general ?

Thanks in advance :o)

Pierre Received on Thu Dec 02 1999 - 11:04:47 CST