ericemc3

icon indicating a website link https://www.icem7.fr

icon company icem7 icon location Toulouse - France icon location Statistician, fond of maps and elegant datavisualisations

Results 43 comments of ericemc3

Poor window function performance compared to a SEMI JOIN equivalent

Thanks! And by the way, i have a brand new PC with an AMD Ryzen 9 HX, RAM 64 GB, so i am surprised that it takes 6-7 s on...

Poor window function performance compared to a SEMI JOIN equivalent

> Hi [@ericemc3](https://github.com/ericemc3) - we had a look and this is currently expected behavior due to a missing optimizer rule for the window function. Hi @taniabogatsch, thank you, but could...

Poor window function performance compared to a SEMI JOIN equivalent

> In your example above we could re-write the query plan in a way that closer matches what we do for the `SEMI JOIN`. However, we do not yet perform...