1 |
3052
|
jones
|
/*
|
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 */
|