Revision 4415
Added by daigle about 16 years ago
| src/xmltables-oracle.sql | ||
|---|---|---|
| 237 | 237 |
* Index of <docid,doctype> in xml_document |
| 238 | 238 |
*/ |
| 239 | 239 |
CREATE INDEX xml_documents_idx1 ON xml_documents (docid, doctype); |
| 240 |
CREATE INDEX xml_documents_idx2 ON xml_documents (lower(user_owner)); |
|
| 240 | 241 |
CREATE INDEX xml_documents_idx3 ON xml_documents (rootnodeid); |
| 241 | 242 |
|
| 242 | 243 |
/* |
| ... | ... | |
| 297 | 298 |
CONSTRAINT xml_access_accessfileid_fk |
| 298 | 299 |
FOREIGN KEY (accessfileid) REFERENCES xml_documents |
| 299 | 300 |
); |
| 301 |
CREATE INDEX xml_access_idx1 ON xml_access (lower(principal_name)); |
|
| 302 |
CREATE INDEX xml_access_idx2 ON xml_access (permission); |
|
| 303 |
CREATE INDEX xml_access_idx3 ON xml_access (perm_type); |
|
| 304 |
CREATE INDEX xml_access_idx4 ON xml_access (perm_order); |
|
| 305 |
CREATE INDEX xml_access_idx5 ON xml_access (subtreeid); |
|
| 300 | 306 |
|
| 301 | 307 |
|
| 302 |
|
|
| 303 | 308 |
/* |
| 304 | 309 |
* Index of Nodes -- table to store precomputed paths through tree for |
| 305 | 310 |
* quick searching in structured searches |
Also available in: Unified diff
Add additional indexed to match postgres scripts