Revision 8335
Added by ben leinfelder over 10 years ago
xmltables-oracle.sql | ||
---|---|---|
303 | 303 |
CREATE INDEX xml_access_idx4 ON xml_access (perm_order); |
304 | 304 |
CREATE INDEX xml_access_idx5 ON xml_access (subtreeid); |
305 | 305 |
CREATE INDEX xml_access_idx6 on xml_access(guid); |
306 |
CREATE INDEX identifier_docid_rev_log ON identifier((docid||'.'||rev)); |
|
306 | 307 |
|
307 | 308 |
|
309 |
|
|
308 | 310 |
/* |
309 | 311 |
* Index of Nodes -- table to store precomputed paths through tree for |
310 | 312 |
* quick searching in structured searches |
... | ... | |
551 | 553 |
date_logged DATE, -- the datetime on which the event occurred |
552 | 554 |
CONSTRAINT access_log_pk PRIMARY KEY (entryid) |
553 | 555 |
); |
556 |
CREATE INDEX access_log_docid ON access_log(docid); |
|
554 | 557 |
|
555 | 558 |
CREATE SEQUENCE access_log_id_seq; |
556 | 559 |
CREATE TRIGGER access_log_before_insert |
Also available in: Unified diff
add 2 indexes to speed up dataONE log retrieval. https://projects.ecoinformatics.org/ecoinfo/issues/6161