I will set up a maintenance task that re-creates the table with the index, in a regular basis. I have not decided how often, I will have to see how fast the performance degrades. For the delete, I will just use a Proc sql delete statement, but the modify performed just as fast. My job will go from 2 hours to 15 minutes. However the maintenance task will take from 30 to 60 mins, depending on how busy is the server. Still a huge gain even if I recreated it every time. Thank you again.
... View more