Hello All
Does anyone know which built-in package features makes SQL calls beginning ‘with KUAFChildrenCTE’? I am examining a system that is performing badly and note a large number of these statements in a single call to CS10 update 08. That call takes 21 seconds but after that it is down to 4 seconds.
This call has raised the large number of project groups the user is a member of that I am looking to lower, but I would like to know why these calls are made in the first place.
I am using MS SQL Server 2008 R2.
Thanks in advance,
Philip Forshaw
CONFIDENTIALITY NOTICE: This e-mail, including any attachments, contains information that may be confidential, and is protected by copyright. It is directed to the intended recipient(s) only. If you have received this e-mail in error please e-mail the sender by replying to this message, and then delete the e-mail. Unauthorised disclosure, publication, copying or use of this e-mail is prohibited. Any communication of a personal nature in this e-mail is not made by or on behalf of any RES group company. E-mails sent or received may be monitored to ensure compliance with the law, regulation and/or our policies.
