Hello,
Stable and immutable functions do not improve performance when used within
the GROUP BY clause.
Here, the function will be called for each row.
To avoid it, I can replace the funtion by its arguments within GROUP BY.
Shame on me !
This is of course bullsh... It has nothing to
Hello,
Stable and immutable functions do not improve performance when used within the
GROUP BY clause.
Here, the function will be called for each row.
To avoid it, I can replace the funtion by its arguments within GROUP BY.
Maybe this hint is worth a note within the documentation on Function