| Partitions [message #93244] |
Wed, 11 February 2004 05:41  |
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  |
Frank Naude
Messages: 4579
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
