Hi. I hope someone can shed some light on a strangeness.

As part of my client's day-end proceedure there is an sql select which select data from two large and one small (~70,000, 2,900,000 and 1 record(s)). Up until a few days ago this ran fine, but three days ago it started to take a VERY long time (after 8 hours it was 13% done) I've tried PACKing the tables but that didn't make any difference.
I will be very grateful for any suggestions as to what could be causing this, and what I can do about it. I am using FPW 2.6