The query is used to check ACL lists on hierarchical objects stored in our sql server 2005 database. Actually, the query duration for 10'000 objects is 1,5 minutes. The goal is to reach a duration of to less than 5 seconds.
More info about this job…