> However, I must confess that I may not know how to get table_statistics to recognize v, v2, v3 and v4 as different tables in the output.
I do it like this:
create table v2 like v; insert into v2 select * from v; ## same for v3, v4
make the different subqueries access the created tables v2, v3, v4.
> However, I must confess that I may not know how to get table_statistics to recognize v, v2, v3 and v4 as different tables in the output.
I do it like this:
create table v2 like v;
insert into v2 select * from v;
## same for v3, v4
make the different subqueries access the created tables v2, v3, v4.