jokershigh comments

Repositories
Issues
Comments

Results 3 comments of


                                            jokershigh

CTE retuns empty instantly, but applying where to the empty set in the main query is slow

If I exclude "AND r."DATA">'2023-10-14'", the query returns instantly

CTE retuns empty instantly, but applying where to the empty set in the main query is slow

Data is a date, not a string. I get the same behaviour with '2023-10-24'. I just executed the query, did not fetch any rows. Plan of the query that returns...

CTE retuns empty instantly, but applying where to the empty set in the main query is slow

Ok. The time it takes is about the same. Adjusted query: WITH raux1 AS ( SELECT p.codprenotacao, p.data, p.protocolo, p.cprotocolo, p.tipo, p.subtipo, i.codigo AS codpessoal, i.nome, i.cadastro FROM PRENOTACOES p,...