Have a look at Chapter 4 of the "Query Performance and Tuning" guide, available at http://developer.marklogic.com/pubs/

-- Mike

Alan Darnell wrote:
I have a set of documents that have volume and issue numbers represented as strings (e.g. 1, 10, 2, 23). If I use the following collation, I get a nice numeric sort without having to pad or otherwise normalize the data, but performance suffers. Is there an index I can add that would speed up the kind of sorting that this collation needs to do?

for $i in cts:search(doc()//article-title,"water")
order by $i/root()//volume collation "http://marklogic.com/collation/en/MO";
return
$i/root()//volume


_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general

Reply via email to