您要查找的是不是：
- Drops, enables, or disables a plan guide. 删除、启用或禁用计划指南。
- This makes sure that the plan guide is used by the query optimizer. 这将确保计划指南可由查询优化器使用。
- Attributes for the plan guide that you expected to match the query. 事件是否包含您希望与查询匹配的计划指南的。
- Plan guides are used for this purpose. 计划指南具有此用途。
- Government intervention planning guide market development is obviously conducive to regional long-term development. 政府出面规划引导市场发展，明显有利于地区的长期发展。
- Trying to drop a table that has a trigger defined on it that is referenced by a plan guide also causes an error. 尝试删除计划指南被引用并已为其定义触发器的表也将导致错误。
- This helps make sure that the plan guide will be matched to the query at compile time. 参数使用。这有助于确保计划指南在编译时与查询匹配。
- Create the plan guide on the parameterized form of the query, specifying the PARAMETERIZATION FORCED query hint. 请指定PARAMETERIZATION FORCED查询提示以对查询的参数化表单创建计划指南。
- You may have to create more than one plan guide to handle different parameter value ranges. 可能必须创建多个计划指南,以处理不同的参数值范围。
- By default, plan guides are enabled at the time they are created. 默认情况下,计划指南在创建时启用。
- Subsequent executions of this query by the application will be affected by this plan guide, and a hash join will be used to process the query. 该计划指南将影响应用程序随后对该查询的执行,并且哈希联接将用来处理该查询。
- Trying to drop or modify a function, stored procedure, or DML trigger that is referenced by a plan guide, either enabled or disabled, causes an error. 如果尝试删除或修改的函数、存储过程或DML触发器由某个计划指南引用,则不管该指南为启用状态还是禁用状态,都会导致错误。
- After a plan guide is disabled, future executions of a query formerly matched by the plan guide are not influenced by the plan guide. 禁用计划指南后,以后再执行以前与该计划指南匹配的查询时将不受该计划指南的影响。
- After a plan guide is dropped, future executions of a query formerly matched by the plan guide are not influenced by the plan guide. 删除计划指南后,以后再执行以前与该计划指南匹配的查询时将不受该计划指南的影响。
- Therefore, to create a plan guide specifying a USE PLAN hint that applies to a query submitted with a cursor request, the plan guide must specify a cursor plan. 因此,计划指南必须指定游标计划,才能创建指定USE PLAN提示(应用于使用游标请求提交的查询)的计划指南。
- For a plan guide to match a batch submitted from an application, batch_text must be provided in the same format, character-for-character, as it is submitted to SQL Server. 对于要与通过应用程序提交的批处理匹配的计划指南,必须按照提交到SQL Server时所采用的格式(字符对字符)来提供batch_tex。
- The following example creates a plan guide that matches any query that parameterizes to a specified form, and directs SQL Server to force parameterization of the query. 以下示例创建一个计划指南,它与被参数化为指定格式的任何查询匹配,并使SQL Server强制执行查询参数化。
- You do this by creating a TEMPLATE plan guide on the parameterized form of the query, and specifying the PARAMETERIZATION FORCED query hint in the sp_create_plan_guide stored procedure. 可以通过在查询的参数化表单上创建TEMPLATE计划指南并在sp_create_plan_guide存储过程中指定PARAMETERIZATION FORCED查询提示来完成此操作。
- He has never dissatisfied with this plan. 他从来没有对计划表示不满。
- Or to API server cursor routines; therefore, they can also be matched by SQL or TEMPLATE plan guides. 或调用API服务器游标例程;因此,它们也可以通过SQL或TEMPLATE计划指南进行匹配。
