Project

General

Profile

« Previous | Next » 

Revision 3070

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/vegbien.sql: Added location.location_coords index to speed up large imports by providing an index for merge joins

View differences:

vegbien.my.sql
4149 4149 

  		




  4150
  4150
  
    

  		




  4151
  4151
  
    
--


  		




  
  4152
  
    
-- Name: location_coords; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  
  4153
  
    
--


  		




  
  4154
  
    

  		




  
  4155
  
    

  		




  
  4156
  
    

  		




  
  4157
  
    

  		




  
  4158
  
    
--


  		




  4152
  4159
  
    
-- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4153
  4160
  
    
--


  		




  4154
  4161
  
    

  		












Also available in:  Unified diff