Project

General

Profile

« Previous | Next » 

Revision 8111

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/FIA/*/postprocess.sql: Cluster tables by their *.unique index for faster joins

View differences:

postprocess.sql
33 33 
$$);
34 34 

  		




  35
  35
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "COND" ADD CONSTRAINT "COND.unique" UNIQUE (".STATECD", ".UNITCD", ".COUNTYCD", ".PLOT", ".INVYR", ".CONDID")$$);


  		




  
  36
  
    
SELECT functions.cluster_once(:table_str, '"COND.unique"');


  		












Also available in:  Unified diff