Hello,
Le 27/04/2021 à 20:52, luis.robe...@siscobra.com.br a écrit :
My question is: is it possible to optimize function order execution?
I guess you could change the cost of one of the functions.
I personally rewrite my queries but I don't know if it's good practice:
WITH pre AS (
SELECT
Hi!
My question is: is it possible to optimize function order execution?
Here's explanation:
I have a bunch of queries that have volatile quals, some more than one. For
example:
SELECT *
FROM clients
WHERE some_func(client_id)
AND some_other_func(client_id)
Now, I know that having vola
