we have one collection with 3,00,000(3 lakhs) xmls and the collection size is 4 gb,on this collection we are running xquery ,this query
taking more than 20 minutes.Here we need to run xquery all 3 lakhs xmls(for report purpose we need to get data from all xmls) .
Note : Same query running very quick on huge size of collction(size more than 30gb) but in this case number of xmls in that collection is
less(nearly 350).
Please suggest any clue to tune the query.