"maricel" <ma*****@xtra.co.nz> wrote in message
news:SL********************@news.xtra.co.nz...
Which one is better in terms of producing optimum performance:
a) Single tablespace that contain multiple containers, say 5 containers of
100MB each container
or
b)Single tablespace that that contain single container, say 1 container of
500MB - same tablespace size as in (a).
Is there any trade-off?
Your help will be appreciated.
Thanks.
maricel
To make the most of using multiple containers, put them on different
physical hard drives (not just partitions on the same hard drive). So if you
have 2 hard drives, use two containers per tablespace. This assumes that
your drives are not already striped with RAID.
If your database is mostly OLTP or queries that access a small number of
rows via indexes, then it will not make much difference. But if you have a
IW database with a lot of tablespace scans or index scans (with prefetch
activity), optimum configuration will probably be noticeable.
Also, having large buffer pools reduces the effect that tablespace
configuration has on performance.