Re: Feature-Request: Performance-Optimization when using limit in combination with order by on querys using union

: under wich circumstance does the query-planner use or prefer the 'merge append' over 'append'? Thanks in advance! Am 08.05.25 um 11:57 schrieb Karsten P: Hi, i've already googled so far but didn't find anything regarding my problem.. I hope i'm here

Feature-Request: Performance-Optimization when using limit in combination with order by on querys using union

Hi, i've already googled so far but didn't find anything regarding my problem.. I hope i'm here at the right place. Following situation (this is just an simplyfied example): suppose we have two tables, lets say orders   - column 'order_number' -> varchar   - column 'order_date' -> timestamp w