Paritions in the same tablespace
ozoracleJul 11 2011 — edited Jul 11 2011Hi,
If I create a partitioned tabled of let's say 5 partitions... but all the partitions are in the same tablespace.
If I then have a SELECT statement from that table which has a WHERE condition based on the partition key column.
Will Oracle take advantage of the partitions to serve the SELECT statment even though the paritions are in the same tablespace?
Do I gain any performance advantage by distributing the partitions in multiple tablespaces?
I have Oracle 10g R1 in a Windows 2003 Server with one storage system attached to it and is used for storing DB datafiles.
Thanks in advance.