Home » Developer & Programmer » Warehouse Builder » Partitions
Partitions [message #93244] Wed, 11 February 2004 05:41 Go to next message
Nauj
Messages: 33
Registered: February 2004
Member
Hello,

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???

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

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.

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


Current Time: Fri Aug 29 15:51:23 CDT 2014

Total time taken to generate the page: 0.13685 seconds