Project

General

Profile

« Previous | Next » 

Revision 12321

schemas/util.sql: materialize_query(): ANALYZE the created table so that it has the correct estimated rowcount

View differences:

util.sql
1692 1692
    LANGUAGE sql
1693 1693
    AS $_$
1694 1694
SELECT util.create_if_not_exists($$CREATE TABLE $$||$1||$$ AS
1695
$$||util.ltrim_nl($2))
1695
$$||util.ltrim_nl($2));
1696
-- make sure the created table has the correct estimated row count
1697
SELECT util.analyze_($1);
1696 1698
$_$;
1697 1699

  
1698 1700

  

Also available in: Unified diff