Home » RDBMS Server » Performance Tuning » Reg Partition
Reg Partition [message #64724] Sun, 11 January 2004 21:14 Go to next message
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 Go to previous message
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.
Previous Topic: understanding execution plans
Next Topic: 1z0-024 questions
Goto Forum:

Current Time: Tue Feb 27 20:09:23 CST 2024