Hi All
I need some help. In our database I have a table which has an average rowsize of 271 (from analyzed statistics). This will contain approx 200 million rows . So the Tablesize comes around approx 57 GB.
I would like to partition this table. So to ensure good performance how many partition I should have?.. I am also not sure about the attribute on which I should partition it. But that may be I can do it on a date attribute which is also being used in the queries executed on this table but I am not sure about the distribution of data on this date. So can I go for hash partitioning of the table on this date attribute. I currently have about 13 tablespaces for data.
Do I need to have more partition than this number.i.e do I need more tablespaces?.......What kind of partitioning is advisable? I am using Oracle 9.2.0.5.0
Please suggest
Thanks in advance.