Long/Skinny table options
I'm building a table that will have 4 columns and a bazzzillion rows.
PK, date, varchar, clob (varray)
I'm considering Index organized and partitioning on date range.
The data will be added to (5k-50k rows/day), but not removed for 7 years or more. It will be queried by date.
What's the best way to store this data?
If I use IOT, will I need to rebuild periodically?
Is it unreasonable to have a partition per day?
What's the best way to create partitions (cron job or pre-created for 10 years)?
Thanks,
Ken