I'm looking to enable users to view query execution plans for tuning queries. Is there any downside to enabling the SHOWPLAN permission to database users in SQL Server? I just want to make sure this won't have a negative impact on general performance.
Asked
Active
Viewed 487 times
1 Answers
5
The ability to view query execution plans does not have any performance implications (except may be they will want to improve their query performance when they see how horrible their plans are). As for security concerns, there are a number of existing answers addressing that.
mustaccio
- 25,896
- 22
- 57
- 72