• How do I trace a query to see where its sticking, I have a good guess where its taking a lot of time but want to make sure. The Oracle variant of this code populates in 4 seconds, but the sql code takes 1.45 over a linked server.