> I need to get the most recent transaction for each customer. I need only
> the transaction ID, but the entire row would be best.
>
Why don't you alter the customer table to hold the transaction ID of the most
recent transaction?
Some questions though:
Do you vacuum the database regularly?
Do you have any indexes created?
Some things to think about.
Andy