Revision 11006
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/VegBank/stemcount_/postprocess.sql | ||
|---|---|---|
| 7 | 7 |
|
| 8 | 8 |
|
| 9 | 9 |
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("aggregateOrganismObservationID")$$); -- runtime: 20 s ("Time: 20194.932 ms") @starscream
|
| 10 |
|
|
| 11 |
SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'__parent'||$$ ON $$||:table_str||$$ ("taxonOccurrenceID")$$); -- runtime: 2 s ("Time: 1766.315 ms") @starscream
|
|
Also available in: Unified diff
bugfix: inputs/VegBank/stemcount_/postprocess.sql: added missing index on taxonOccurrenceID, needed for the 1:many portion of the taxon_observation.** left-join