Hello,
Le 27/04/2021 à 20:52, luis(dot)roberto(at)siscobra(dot)com(dot)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 client_id
FROM clients
WHERE some_other_func(client_id)
)
SELECT *
FROM clients
JOIN pre USING(client_id)
WHERE some_func(client_id)
Best regards,
JC