Here is the situation:
My application creates a record in the table A for each of the user session
with a unique ID and some other user information. After a while this table
is getting huge(think of billions of rows). We want to get rid of some old
or unused data from the table in order to improve performance (the table is
well-indexed though). We certainly don't want to try the 'delete' because
that would lock the table and cause problem for our live application.
Does any one know of any good way dealing with this kind of issue?