Re: Where to store indexes for partitioned tables?

Hi,
well whether you store indexes and tables separate boils down to a matter of personal taste. In particular with the SAN/NAS storage that is typically used nowadays. I tend to group segments by their logical usage, i.e. everything that belongs to a schema/application goes into the same tablespace. way easier to do point-in-time restore that way. (i.e. i accidentally dropped that table, can you restore that for me ...), or for building test environments.

Only when you get more than say 10-20G i would bother with several tablespaces. But that really depends on the environment: some shops consider a 200GB database mid-sized, some others thinks it's huge.

I would put the indexes into the same tablespace as the tables unless you are dealing with large amounts of data. less work less hassle. i tend to be lazy in that regard

Karsten Received on Fri Jan 28 2005 - 13:17:48 CST