Create table for append only

From: Andrea <netsecurity_at_tiscali.it>
Date: Fri, 23 May 2008 06:04:10 -0700 (PDT)
Message-ID: <111482f0-3126-498f-8376-5203475697ea@s50g2000hsb.googlegroups.com>


Hi guys,
sorry for my question but i would like to give some tips for create a table in 10g database.
This table have 40 colums and start with few rows, about 2 thousand, but it will increase soon (it appends hundred rows every day) only through append transactions. I thinked to create a IOT table (index organized) and maybe partition it also.

So if this kind of table has not updates but only append and select, which are the best practices in this case?

thanks for advice
Andrew Received on Fri May 23 2008 - 08:04:10 CDT

Original text of this message