Project

General

Profile

Revision 7455

additional db indexes for pathquery performance
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5696

View differences:

upgrade-db-to-2.0.5-oracle.sql
6 6
 * for use in 2.0.5. So, we do nothing here for Oracle deployments.
7 7
 */
8 8

  
9
/*
10
 * Add some additional indexes for search
11
 */
12
CREATE INDEX xml_documents_idx5 ON xml_documents (docid, rev);
9 13

  
14
CREATE INDEX xml_access_idx6 on xml_access(guid);
15

  
16
CREATE INDEX identifier_guid on identifier(guid);
17
CREATE INDEX identifier_docid on identifier(docid);
18
CREATE INDEX identifier_rev on identifier(rev);
19
CREATE INDEX identifier_docid_rev on identifier(docid, rev);
20

  
21
CREATE INDEX xml_path_index_idx6 ON xml_path_index (docid);
22

  
23

  
10 24
/*
11 25
 * update the database version
12 26
 */

Also available in: Unified diff