X-Git-Url: http://gitweb.michael.orlitzky.com/?p=dead%2Fcensus-tools.git;a=blobdiff_plain;f=sql%2Fcombine-block-tables.sql;h=229cd66ff8d00daa23dae47868627f86a5031339;hp=a9dccd98dfbfe6156a9db98852ba2df8050f03b7;hb=ebe7b7fbc792372f531fc11e14fa1c1dc8551da2;hpb=4ab0591f5fd8019a0e847a11d1d87b5481f5d28a diff --git a/sql/combine-block-tables.sql b/sql/combine-block-tables.sql index a9dccd9..229cd66 100644 --- a/sql/combine-block-tables.sql +++ b/sql/combine-block-tables.sql @@ -22,3 +22,6 @@ DROP TABLE tiger_blocks; /* We have to re-create the GiST index on the new table as well. */ CREATE INDEX idx_geometry_gist ON blocks USING gist(the_geom); + +/* And generate some statistics. */ +ANALYZE blocks;