Project

General

Profile

Actions

Task #494

closed

add indexes for the analytical_db_view joins

Added by Aaron Marcuse-Kubitza over 11 years ago. Updated over 11 years ago.

Status:
Resolved
Priority:
Normal
Start date:
09/18/2012
Due date:
% Done:

100%

Estimated time:
Activity type:

Description

  • *_unique indexes are often used in joins, but some (such as locationevent_unique_within_location) have filter conditions that prevent their use

The following tables need join indexes:

  • locationevent on location_id
  • taxonoccurrence on locationevent_id
  • aggregateoccurrence on taxonoccurrence_id
  • specimenreplicate on plantobservation_id
Actions

Also available in: Atom PDF