This is a good canidate to partion however table already created and no time to rewrite porcess. On a daily basis the delete is OKAY about 100K records. The process I am dealing with is a historical rerun.
This is a problem with the database design and/or the users changing thier minds on what is needed. Just going to have to use a bigger hammer to get this done.
I assume that you mean drop and recreate the table with partitions.
I don't think that a table can be modified to add partitions where partitions never existed. If a table can be modified to add partitions could you supply me with a link so that I can leverage this in the future.
Thanks in advance.
I will look into partioning however with accessing 20% of the table I don't think that partitioning will help.
I finally got my records deleted. Used a bigger hammer.