Revision 3506
Added by Jing Tao over 17 years ago
src/upgrade-db-to-1.7.1.sql | ||
---|---|---|
1 | 1 |
CREATE INDEX xml_index_idx2 ON xml_index (docid); |
2 | 2 |
CREATE INDEX xml_nodes_idx4 ON xml_nodes (docid); |
3 |
CREATE INDEX xml_documents_idx3 ON xml_documents (rootnodeid); |
|
4 |
CREATE INDEX xml_index_idx3 ON xml_index (nodeid); |
Also available in: Unified diff
Add two indexes to improve delete and update speed.