New query tuning options support the capabilities of named caches and provide additional control when tuning queries:
The set forceplan on command forces SQL Server to join the tables in a query in the order in which they are listed in the from clause.
The set table count command allows you to specify the number of tables that are considered at once as joins are optimized.
The new system procedure sp_cachestrategy disables and reenables cache strategies and large I/O for individual objects.
New clauses for select, delete, and insert commands allow you to specify the index, cache strategy, or I/O size for a query.
The set prefetch command allows you to enable or disable large I/O for a session.
See Chapter 10, “Advanced Optimizing Techniques,” in the Performance and Tuning Guide for information on query processing options that control caching strategies and I/O size.
