Hi,

While your table has more then 100 mil. why you don't try to crete triggers and one another table. Changes on primary table such as delete or insert should update...