Revision 3503
Added by Jing Tao almost 17 years ago
| xmltables.sql | ||
|---|---|---|
| 234 | 234 |
* Index of <docid,doctype> in xml_document |
| 235 | 235 |
*/ |
| 236 | 236 |
CREATE INDEX xml_documents_idx1 ON xml_documents (docid, doctype); |
| 237 |
CREATE INDEX xml_documents_idx3 ON xml_documents (rootnodeid); |
|
| 237 | 238 |
|
| 238 | 239 |
/* |
| 239 | 240 |
* Revised Documents -- table to store XML documents saved after an UPDATE |
| ... | ... | |
| 318 | 319 |
*/ |
| 319 | 320 |
CREATE INDEX xml_index_idx1 ON xml_index (path); |
| 320 | 321 |
CREATE INDEX xml_index_idx2 ON xml_index (docid); |
| 322 |
CREATE INDEX xml_index_idx3 ON xml_index (nodeid); |
|
| 321 | 323 |
|
| 322 | 324 |
|
| 323 | 325 |
/* |
Also available in: Unified diff
Add two indexes to improve peformance of deleting and update