Project

General

Profile

Revision 7455

additional db indexes for pathquery performance
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5696

View differences:

xmltables-oracle.sql
238 238
CREATE INDEX xml_documents_idx1 ON xml_documents (docid, doctype);
239 239
CREATE INDEX xml_documents_idx2 ON xml_documents (lower(user_owner));
240 240
CREATE INDEX xml_documents_idx3 ON xml_documents (rootnodeid);
241
CREATE INDEX xml_documents_idx5 ON xml_documents (docid, rev);
241 242

  
243

  
242 244
/*
243 245
 * Revised Documents -- table to store XML documents saved after an UPDATE
244 246
 *                    or DELETE
......
300 302
CREATE INDEX xml_access_idx3 ON xml_access (perm_type);
301 303
CREATE INDEX xml_access_idx4 ON xml_access (perm_order);
302 304
CREATE INDEX xml_access_idx5 ON xml_access (subtreeid);
305
CREATE INDEX xml_access_idx6 on xml_access(guid);
303 306

  
304 307

  
305 308
/*
......
364 367
CREATE INDEX xml_path_index_idx2 ON xml_path_index (nodedata);
365 368
CREATE INDEX xml_path_index_idx3 ON xml_path_index (nodedatanumerical);
366 369
CREATE INDEX xml_path_index_idx4 ON xml_path_index (nodedatadate);
370
CREATE INDEX xml_path_index_idx6 ON xml_path_index (docid);
367 371

  
368 372

  
369

  
370

  
371 373
CREATE TABLE xml_relation (
372 374
	relationid    NUMBER(20) PRIMARY KEY, -- unique id
373 375
	docid         VARCHAR2(250),          -- the docid of the package file
......
451 453
   docid  VARCHAR2(250),  -- the local document id #
452 454
   rev    NUMBER(8)       -- the revision part of the local identifier
453 455
);
456
CREATE INDEX identifier_guid on identifier(guid);
457
CREATE INDEX identifier_docid on identifier(docid);
458
CREATE INDEX identifier_rev on identifier(rev);
459
CREATE INDEX identifier_docid_rev on identifier(docid, rev);
454 460

  
455 461
/*
456 462
 * accesssubtree -- table to store access subtree info

Also available in: Unified diff