Project

General

Profile

Actions
Copy link

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
Assignee:
Aaron Marcuse-Kubitza
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
Copy link
 #1

Updated by Aaron Marcuse-Kubitza over 11 years ago

  • Description updated (diff)
Actions
Copy link
 #2

Updated by Aaron Marcuse-Kubitza over 11 years ago

  • Description updated (diff)

Indexes added on locationevent, taxonoccurrence, aggregateoccurrence

Actions
Copy link
 #3

Updated by Aaron Marcuse-Kubitza over 11 years ago

  • % Done changed from 0 to 80
Actions
Copy link
 #4

Updated by Aaron Marcuse-Kubitza over 11 years ago

  • Description updated (diff)
  • Status changed from New to Resolved
  • % Done changed from 80 to 100

Index added on specimenreplicate

Actions
Copy link

Also available in: Atom PDF