Andrew Edson <cheighlund@xxxxxxxxx> writes: > A copy of the statement and explain results on it appear below. Would someone please assist me in figuring out how to more appropriately streamline this statement? The lack of any applicable index on ttrans seems to be the biggest problem. regards, tom lane