Re: Where to store indexes for partitioned tables?

Hi,
In general i consider it a bad idea to have one tablespace for each partition in the 'sliding window' scenario. the poor dba that needs to create a new tablespace and drop an old one each month.
then sizing. How do you size the new tablespace ? probably larger that the prev month, sind data volume tends to grow always. then you need to go back avter the old slice is not active, and re-size, or else you waste space.

then you probably want to take a new full backup after you changed the db structure. that list goes on.

unless you are the only person that is ever going to administer that database, just throw it all into one bucket.

Karsten Received on Fri Jan 28 2005 - 06:17:15 CST