Project

General

Profile

« Previous | Next » 

Revision 13404

Added by Aaron Marcuse-Kubitza over 10 years ago

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _plots_21_tnrs_output_names: removed no longer needed disabling of enable_hashjoin (the lack of an additional join now makes `SET enable_seqscan = off;` sufficient to prevent a slow hash join)

View differences:

trunk/validation/aggregating/plots/bien3_validations_salvias_vegbien.sql
352 352 
*/
353 353 

  		




  354
  354
  
    
-- _plots_21_tnrs_output_names


  		




  355
  
  
    
SET enable_hashjoin = off;


  		




  356
  355
  
    
 SELECT DISTINCT taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name


  		




  357
  356
  
    
   FROM (taxonlabel


  		




  358
  357
  
    
   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))


  		




  359
  358
  
    
  WHERE ((taxonlabel.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));


  		




  360
  
  
    
SET enable_hashjoin = DEFAULT;


  		




  361
  359
  
    
/*


  		




  362
  360
  
    
The second check should focus on determining if Aaron is reconstructing


  		




  363
  361
  
    
morphospecies names correctly. The TNRS stores the morphospecies part of the


  		












Also available in:  Unified diff