| Question about partitioning [message #174419] |
Mon, 29 May 2006 04:06  |
Nau
Messages: 24
Registered: October 2004
|
Junior Member |
|
|
I'm working in a data warehouses with typical facts tables.
Some of my fact tables are big and I want to partition them.
I want to know the criterions of partitioning. is there any rules??
For example:
- Number of rows of the table or the partitions.
If I put partitions on my tables, the tables will have 1 million records in each partitions???, is a good number???
What are the advantages and disadvantages of partitions???.
I have massive load process and masive delete/truncate process. Have partitions any effect on this processs??
Any advice about partitioning will be greatly apreciatted.
|
|
|
|
| Re: Question about partitioning [message #174535 is a reply to message #174419] |
Mon, 29 May 2006 08:13  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
You can have any number of rows per partition - 1 million is not unreasonable. Try to size them so that a FULL PARTITION SCAN would not take longer than say 10 minutes (or any other number agreed with your users).
The goal should be to make the database faster as it grows bigger by making the partitions smaller.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
