Revision 3506
Added by Jing Tao over 16 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.