473,386 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Deletion of 10 million records from a table

In a table I have 40 million records out of which I need to delete around 10 million records every year. We use Load replace technique for this. But it consumes lot of time. Is there any possibility by using Reorg/Discard Utility or by using SQL query for deleting the records (In intervals, each time around 1 Lakh records) can we reduce the CPU time and increase the performance of the deletion activity?
Oct 6 '14 #1
2 1434
Rabbit
12,516 Expert Mod 8TB
Expand|Select|Wrap|Line Numbers
  1. DELETE FROM tableName
  2. WHERE <criteria that defines the records to delete>
Oct 6 '14 #2
Luuk
1,047 Expert 1GB
You could use something like partitioning on that table

read more about that here:
http://www.ibm.com/developerworks/da...dm-0605ahuja2/
Oct 11 '14 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Warren Wright | last post by:
Hello, We maintain a 175 million record database table for our customer. This is an extract of some data collected for them by a third party vendor, who sends us regular updates to that data...
1
by: gooogle | last post by:
Hi, We need to log the fields from a IIS log into some database where it can be sorted by date and id of a record. There will be about a million records per day or more than that may be. What...
2
by: PeteCresswell | last post by:
This is pursuant to another thread I tried to start, but can't find on my server. I've got to store rolling rates of return for investment funds - calendar year, quarterly, and monthly To cut...
2
by: technocrat | last post by:
I am trying to load from a cursor which selects 124 million records...but while loading it completes the build phase and it stuck ...I think...at the delete phase(which in turn looks like doing the...
1
by: achurin | last post by:
Hi everybody, I am a rookie at the forum stuff. Please don't bash me too badly. I have created an app a few years back to store some records in a DB. According our calculations we were never to...
1
by: B | last post by:
Hello All, This is my first time using this list, but hopefully I got the right one for the question I need to ask :). I have a table which has about 4 million records. When I do a search...
4
by: alex.hatzisavas | last post by:
Dear all, I'm trying to do a selective deletion from an 'Archive' table based on dates. Here is the setup: Table 'Archive' has a date field ( ). Another table ('Cutoffs') defines the Low...
3
by: Arne Reed | last post by:
I work at a Community College. I have been using Access for 4 years to track the number and destinations of transcripts we mail out at students' (and former students' requests). It has worked...
8
by: sxs1 | last post by:
I have performance issue with the query which takes 5-10 mins and has table has very less number of records something arround a million records.I need to insert the filtered data into a global temp...
0
by: reachwasim | last post by:
I have a project to handle where there are close to 50 to 60 million records. My job would be migrating the data from textfile to a database and then develop a UI to query the data. My only...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.