Doubt on partitions

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 Received on Thu Feb 22 2007 - 03:27:50 CST