Great catch, Jason.
It may be worth testing an alternate of
ORDER BY capture_time DESC NULLS LAST
rather than adding the IS NOT NULL test with regard to performance. Reason being, the plans may be different in the details, and use different indexes.
Great catch, Jason.
It may be worth testing an alternate of
ORDER BY capture_time DESC NULLS LAST
rather than adding the IS NOT NULL test with regard to performance. Reason being, the plans may be different in the details, and use different indexes.