Project

General

Profile

« Previous | Next » 

Revision 4415

Added by daigle over 15 years ago

Add additional indexed to match postgres scripts

View differences:

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