| Reg Partition [message #64724] |
Sun, 11 January 2004 21:14  |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
We have a table with 30 million records
the delete is based on cycle count..
but the key is another column
If i create a table with 5 partitions..
based on the key colum where the cycle count will be in all the partitions
If i create a table with 5 partitions with cycle count as the partition key
so that delete issued for a particular cycle count
it will go to one partition
which one is better ?
|
|
|
|
| Re: Reg Partition [message #64728 is a reply to message #64724] |
Tue, 13 January 2004 14:40  |
Mike
Messages: 417
Registered: September 1998
|
Senior Member |
|
|
|
if you chose your second option the "delete" will be much faster because instead of deleting your rows but you can simply truncate your partition.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
