小结: 本文简要介绍SQL Server三种不同类型的联接提示(Join Hints)、查询提示(Query Hints)、表提示(Table Hints),包括SQL Server2008中引入的提示ForceSeek,可以用它将索引查找来替换索引扫描。
基于66个网页-相关网页
Other functions that are standardized in JPA 2.0 are a level 2 cache plug-in, as well as query hints (also known as access intents).
JPA 2.0中标准化的其他功能包括二级缓存插件和查询提示(也称为访问意图)。
Plan guides are a particularly nifty thing. They allow you to supply query hints to stored procs that you can change as well as ad-hock queries created by applications.
计划指南是个好东西,凭借它你可以在存储过程(你可以修改存储过程,也可以ad - hock应用创建的查询)中使用query hint。
All that remains now is to create a hints file to add some data to your query.
现在剩下的就是创建提示文件以便将一些数据添加到您的查询。
应用推荐