Home » RDBMS Server » Performance Tuning » Reg Partition
- Reg Partition [message #64724] Sun, 11 January 2004 21:14 Go to next message
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 ?

Report message to a moderator

- Re: Reg Partition [message #64728 is a reply to message #64724] Tue, 13 January 2004 14:40 Go to previous message
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.

Report message to a moderator

Previous Topic: understanding execution plans
Next Topic: 1z0-024 questions
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 05 01:09:34 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.