Hi: Take the following example:
insert into cte1 select i, i from generate_series(1, 1000000)i; create index on cte1(a); explain with cte1 as (select * from cte1) select * from c where a = 1; It needs to do seq scan on the above format, however it is pretty quick if we change the query to select * from (select * from cte1) c where a = 1; I know how we treat cte and subqueries differently currently, I just don't know why we can't treat cte as a subquery, so lots of subquery related technology can apply to it. Do we have any discussion about this? Thanks -- Best Regards Andy Fan
