Revision 11466
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbien.sql | ||
|---|---|---|
| 1272 | 1272 |
CREATE INDEX ON analytical_stem ("datasource", "occurrenceID");
|
| 1273 | 1273 |
CREATE INDEX ON analytical_stem ("datasource", "specimenHolderInstitutions", "collection", "accessionNumber");
|
| 1274 | 1274 |
CREATE INDEX ON analytical_stem ("datasource", "projectID", "locationID", "dateCollected");
|
| 1275 |
CREATE INDEX ON analytical_stem ("speciesBinomialWithMorphospecies");
|
|
| 1275 |
CREATE INDEX ON analytical_stem ("speciesBinomialWithMorphospecies"); -- runtime: 1 h ("3953941 ms") @vegbiendev
|
|
| 1276 | 1276 |
|
| 1277 | 1277 |
-- Re-create dependent objects |
| 1278 | 1278 |
IF analytical_plot_def IS NOT NULL THEN |
Also available in: Unified diff
schemas/vegbien.sql: sync_analytical_stem_to_view(): speciesBinomialWithMorphospecies index: documented runtime (1 h)