--- trunk/dbxml/total.q 2005/10/22 15:40:38 221 +++ trunk/dbxml/total.q 2005/10/22 15:40:42 223 @@ -3,7 +3,12 @@ openContainer backuppc.dbxml -queryPlan 'collection("backuppc.dbxml")/opt[host]' +queryPlan 'collection("backuppc.dbxml")/file/host/text()' +queryPlan 'collection("backuppc.dbxml")/file/host/text() = "llin"' +query 'collection("backuppc.dbxml")/file/host' +addIndex "" file-host node-element-presence-none +queryPlan 'distinct-values(collection("backuppc.dbxml")/file/host/text())' addIndex "" host node-element-presence-none -queryPlan 'collection("backuppc.dbxml")/opt[host]' -query 'collection("backuppc.dbxml")/opt[host]' +queryPlan 'distinct-values(collection("backuppc.dbxml")/file/host/text())' +query 'distinct-values(collection("backuppc.dbxml")/file/host/text())' +print