Thanks Pablo, Bruce.

From your suggestions, I think I must check for archiving/purging of data.

As I already mentioned, I wanted to partition my table in 2 parts :

1. With active (useful)...

Thanks Paul,

I got it. I wanted to partition it, only for performance.

This is the most heavily used table in our system. I can dare and say its one of...