What is the right approach of DQL query tuning when a user complains about performance problems?

What is the right approach of DQL query tuning when a user complains about performance problems?
A. 1. trace operation with the Content Server installation owner account 2. locate SQL statement in session logfile 3. get the query plan for this SQL statement using database tools 4. tune the query and re-test the operation
B. 1. trace operation with the user or a user equivalent account 2. locate SQL statement in session logfile 3. get the query plan for this SQL statement using database tools 4. tune the query and re-test the operation
C. 1. trace operation with the user account 2. locate SQL statement in agentexec logfile 3. get the query plan for this SQL statement using database tools 4. tune the query and re test the operation
D. 1. trace operation with the repository owner account 2. locate SQL statement in agentexec logfile3. get the query plan for this SQL statement using database tools 4. tune the query and re- test the operation

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.