Home » Developer & Programmer » Data Integration » Partitions
Partitions [message #93244] Wed, 11 February 2004 05:41 Go to next message
Messages: 33
Registered: February 2004

I have a table partitioned by three columns. It has about 5Gb data. The advantage of the partitions is:

- Lower timeresolving querys  

- I can make truncates of partitions (never deletes)

But, The numbers of partitions is over 1000 and continue growing..., is there any disadvantage in a high number of partitions???

Re: Partitions [message #93247 is a reply to message #93244] Fri, 13 February 2004 03:42 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member

I don't think there are any disadvantages of having thousands of partitions, except manageability. Though, separate tables or separate smaller partitioned tables will always be better!

Best regards.

Previous Topic: Oracle Warehouse Feedback
Next Topic: Moving Warehouse data from one OS to another.
Goto Forum:

Current Time: Sun May 19 11:46:45 CDT 2024