Tamino performance 2


As it is possible to raise productivity of inquiry ?

for $AccountUser in input()/so/ACCOUNTUSER, $SystemModule in input()/so/SYSTEMMODULE sort by (ACCOUNT_ID)
where $SystemModule/SYSTEM_ID = $AccountUser/SYSTEM_ID and $SystemModule/CLIENT_ID = $AccountUser/CLIENT_ID and $AccountUser/CLIENT_ID=1 return …

what indexes I should make ?


You have two join predicates, one search predicate and one sort criteria.
I would suggest to put a (standard) index on all elements referenced by the predicates and the sort criteria. This means an index on the following element would increase the performance of your query:


Best Regards,