I have a Person structure XML like this exemple:
I write this Xquery:
for $pers in (input()/Person[@Name='Benoit' and @Valid=1 and @Vorname='Albert' and Address[Street and not(PNumber) and not(City)]])[position() > 0 and position() <= 10] return $pers
When I execture this Xquery I wait a few minutes before to receive an answer!!!
However, I have a Text index on City et PNumber!
Has anyone an idea, how can I improve the performance of my xquery?
Thank you for your help!