Revision 7120
Added by Aaron Marcuse-Kubitza almost 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 3408 | 3408 |
|
| 3409 | 3409 |
|
| 3410 | 3410 |
-- |
| 3411 |
-- Name: VIEW unscrubbed_taxondetermination_view; Type: COMMENT; Schema: public; Owner: - |
|
| 3412 |
-- |
|
| 3413 |
|
|
| 3414 |
|
|
| 3415 |
|
|
| 3416 |
|
|
| 3417 |
-- |
|
| 3411 | 3418 |
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 3412 | 3419 |
-- |
| 3413 | 3420 |
|
Also available in: Unified diff
schemas/vegbien.sql: unscrubbed_taxondetermination_view: Sort by taxondetermination.taxonoccurrence_id instead of taxondetermination_id to allow scanning the taxondetermination_single_current_determination index, which includes only current determinations and avoids needing to scan past many non-current determinations. Note that using taxonoccurrence_id does not create sort order ambiguity between taxondeterminations with the same taxonoccurrence_id, because there is only one current determination per taxonoccurrence.