SQLite Forum

Possible WINDOW optimization opportunity
Login

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.