One of our trial customer has the following questions related to SQL Optimizer for SQLServer:
- We used the SQL Optimizer Rewrite Query feature and received a few suggestions. We noticed that some of the suggested optimized queries requires high level of access rights (e.g. QUERYTRACEON option) which may not be suitable in certain scenarios. Are there any configurations or options that we are able to limit the suggestions to accounts with limited access?
- I would also like to know if there are any method to optimize the queries that are created as a result of using LINQ? I could not find any reference to this in our documentation.
- What would be the likely scenario to use the Manage Plan feature instead of the Rewrite Query feature? Is there any use case or video article available on when and how this feature helps?
Can you please advise on the above?