DPSPayment indexes for better select performance

On an table with 70k orders on SQL Server, we saw 15s times for a simple
"SELECT FROM ... WHERE TxnRef = ...".