Does Table Partition Slows System

[amerbaig]

I have range partition five tables, each partition points to separate and specific tablespace. I have planned to place tablespace on different disks to gain parallelism. But right now I don't have many disk so I use one IDE harddisk. The moment I implemented partitioning performace of inserts get down substantially. But exceptionally system performed best when I run it first time. I am on Oracle and each table contains 10's millions of rows. Any solutions. Also recommend me block size and table partition sizes, storage sizes etc. I would be obliged


Amer

 

[Kenrae]

Partitions speed up your system when you have groups of users who usually use the same range of data. By storing this data near them, you speed transmissions.
It also speed up your system for queries that search for a small range of data (like joins), localized only on one or two partitions, since it only has to search for the partitions needed.
Inserts will usually be slower, as system search where to put new data before inserting it, but it shouldn't be much slower. Maybe there's some indexes there that bother you? I don't know.

 

[amerbaig]

No Indeses --- I agree with all comments, but I am not sure about the performance issues.

Regards
Amer