Hi to all

  • SQL DBA or Developer can create the actual execution plan ?

  • Execution plan is created by the database engine. You need suitable permision excute the query. Then only execution plan gets created.

  • 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

  • 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