• *_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