Project

General

Profile

« Previous | Next » 

Revision 3412

Added by Jing Tao almost 17 years ago

Create index to speed deleting.

View differences:

xmltables-postgres.sql
78 78
CREATE INDEX xml_nodes_idx1 ON xml_nodes (rootnodeid);
79 79
CREATE INDEX xml_nodes_idx2 ON xml_nodes (parentnodeid);
80 80
CREATE INDEX xml_nodes_idx3 ON xml_nodes (nodename);
81
CREATE INDEX xml_nodes_idx4 ON xml_nodes (docid);
81 82

  
82 83

  
83 84
/*

Also available in: Unified diff