Possible WINDOW optimization opportunity
(1) By anonymous on 2021-04-07 15:06:27 [source]
Unless my assumption that 0 PRECEDING
and 0 FOLLOWING
is functionally equivalent to CURRENT ROW
is incorrect, there is (based on EXPLAIN
output) an optimization opportunity to replace the former with the latter as it produces fewer steps.