Project

General

Profile

metacat / src / upgrade-db-to-1.7-postgres.sql @ 8556

1
/*
2
 * New indexes to make queries avoid full table scans.
3
 */
4
CREATE INDEX xml_documents_idx2 ON xml_documents (lower(user_owner));
5
CREATE INDEX xml_access_idx1 ON xml_access (lower(principal_name));
6
CREATE INDEX xml_access_idx2 ON xml_access (permission);
7
CREATE INDEX xml_access_idx3 ON xml_access (perm_type);
8
CREATE INDEX xml_access_idx4 ON xml_access (perm_order);
9
CREATE INDEX xml_access_idx5 ON xml_access (subtreeid);
10
CREATE INDEX xml_path_index_idx4 ON xml_path_index (upper(nodedata));
11

    
12
/** done */