July 18, 2011 at 1:59 am
SQL DBA or Developer can create the actual execution plan ?
July 18, 2011 at 2:06 am
Execution plan is created by the database engine. You need suitable permision excute the query. Then only execution plan gets created.
July 18, 2011 at 11:50 am
In order for a person to retrieve the Actual Execution Plan the login must be granted the SHOWPLAN permission. sysadmin's, database owners and members of the db_owner role have this permission by default. You can grant the permission on an individual basis to lesser privileged users as well.
From http://technet.microsoft.com/en-us/library/ms189562.aspx:
To use this feature, users must have the appropriate permissions to execute the Transact-SQL queries for which a graphical execution plan is being generated, and they must be granted the SHOWPLAN permission for all databases referenced by the query. For more information, see Showplan Security.
This article details the permissions necessary to see showplans:
http://technet.microsoft.com/en-us/library/ms189602.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 19, 2011 at 4:09 pm
sonwane.pratibha (7/18/2011)
SQL DBA or Developer can create the actual execution plan ?
Using query or join hints, the developer can influence the decisions that SQL Server makes when it creates the actual execution plan; for example which index or join type to use. Using sp_create_plan_guide, the DBA can create Plan Guides which can be used to associate hints to SQL statements that match a specific pattern.
Query Hints
http://msdn.microsoft.com/en-us/library/ms181714.aspx
Understanding Plan Guides
http://msdn.microsoft.com/en-us/library/ms190417.aspx
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply