Project

General

Profile

« Previous | Next » 

Revision 7244

schemas/vegbien.sql: analytical_stem_view: Changed `WHERE COALESCE` to a join condition to enable using the taxondetermination_single_current_determination index, which produces the filtered rows directly. Note that this index will not be used for full-database imports, because the query planner uses hash joins everywhere instead of nested loops.

  • added
  • modified
  • copied
  • renamed
  • deleted