Hi Gurus,

I would like to know how the criteria could be to cosider partitions for a
table?. Let me put it in a more clear way. Suppose i have a table of record
size 173 bytes and the number of records in this table is going to about
500,000. then the total size of the table with the full set of records will
be about 82MB.
Now i want to create a separate tablespace that too partitioned tablespace
for this table as the no of records are going to more. but the size of the
table is less than 100 mb. in this case how would i go about?. just simply
create one tablespace as the total size is just 82 mb. or because the no of
records are more, to speed up the processing time, should i go for
partitioned table?. in this case if i go for 5 partitions , say for
instance, do i need to create each partition with a size of 20MB. is it a
feasible database design to have such small tablespace size. will solve my
purpose of improving the performance by keeping partitioned tablespaces? or
even single tablespace which holds 500,000 records will give the same
performance?. Can any body throw some light on this please?. your
suggestions are greatley appreciated.

TIA
Chandra Sekhar
Oracle LazyDBA home page