Cross Apply Timing Out on Large (1bn rows) Table

SQLServerCentral » Latest topics

Cross Apply Timing Out on Large (1bn rows) Table

I have a small table Members (1000 rows) that contains member information.
I have a large view History (1bn rows) that contain member transaction history.

I need to find the latest transaction in History for each Member. I tried using Cross A

more info...