| Question on Partitions. [message #151139] |
Tue, 13 December 2005 07:26  |
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
|
Senior Member |
|
|
hi,
I want to know the best possible partition option for the below scenario ..
there is a table per say Department ..
Dno, dname and loc with around 3 million records ..
there are around 1000 dno's in the table (there is no specific order) .. and each department has around 30000 entries ..
I want to partition this table to hold 10 department numbers into each partition ..
Let me know your comments ..
-Sai Jeedigunta
|
|
|
|
| Re: Question on Partitions. [message #151148 is a reply to message #151139] |
Tue, 13 December 2005 07:39  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Sounds like and excellent opportunity to use RANGE PARTITIONING:
...
PARTITION BY RANGE (dno)
( PARTITION range1 VALUES LESS THAN (10),
PARTITION range2 VALUES LESS THAN (20),
...
Do you have licenses to use the partitioning option?
Best regards.
Frank
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Question on Partitions. [message #151162 is a reply to message #151139] |
Tue, 13 December 2005 08:25 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
It sounds like, given your response to Frank's suggestions, that you don't really want to partition this after all. Why not make it an index organized table instead? With only 1000 unique dno's, with lots of occurances each, that would group all of the locations together into blocks that were next to each other.
Assuming you are trying to answer questions such as give me all the locations for such and such dno. Which I'm assuming based on your desire to partition by that column.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
Not again ..i am not sure that even alphabetical standard is being followed ..any other parition options available for this frank ???