Giridhar wrote:
>
> Hi,
> i have a table which has 12 partitions (each with 4 million rows).
> This table stored data for each month in a partition. My query will
> mostly consist of the date on which the table is partitioned.
>
> Is it advisable to store data (data and indexes) for all partitions in
> one tablespace or should i store different tablespaces? Which option
> is good for better performance.
>
> Thanks
> Giridhar
Different tspaces gives you some more options, eg make older data
read-only, take partitions offline for moving around etc etc
--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"Semper in excremento, sole profundum qui variat."
------------------------------------------------------------
Received on Thu Feb 22 2007 - 05:33:45 CST
