TEMPLATE plan guides match stand-alone queries that parameterize.SQL-based plan guides can also be used to match queries that parameterize to Transact-SQL statements and batches that are not part of a database object. SQL plan guides match queries that execute in the context of stand-alone.Stored procedures, scalar functions, multistatement table-valued functions, OBJECT plan guides match queries that execute in the context of Transact-SQL. The followingĮxcerpt from the SQL Server Books Online summarizes them: There are 3 types of plan guides that you can create. However, it should be noted that this is an advanced feature and should be Not available or because it's contractually prohibited), this can be a very useful In situations where you cannot modify source code (either because it's Hints to specific queries without the invasiveness of directly changing any queries SQL Server 2005 introduced plan guides which allow you to add
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |