Project

General

Profile

« Previous | Next » 

Revision 3347

Added by Jing Tao over 17 years ago

Add new index into xml_index table.

View differences:

src/xmltables.sql
316 316 
 * Index of the paths in xml_index
317 317 
 */
318 318 
CREATE INDEX xml_index_idx1 ON xml_index (path);
319 
CREATE INDEX xml_index_idx2 ON xml_index (docid);
319 320 

  		




  320
  321
  
    

  		




  321
  322
  
    
/*


  		












  

    
      src/xmltables-postgres.sql
    
  





  245
  245
  
    
 * Index of the paths in xml_index


  		




  246
  246
  
    
 */


  		




  247
  247
  
    
CREATE INDEX xml_index_idx1 ON xml_index (path);


  		




  
  248
  
    
CREATE INDEX xml_index_idx2 ON xml_index (docid);


  		




  248
  249
  
    

  		




  249
  250
  
    
CREATE SEQUENCE xml_relation_id_seq;


  		




  250
  251
  
    
CREATE TABLE xml_relation (


  		












Also available in:  Unified diff