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.
现在剩下的就是创建提示文件以便将一些数据添加到您的查询。
It gives hints and tips to determine whether an MQT is being used by the query and, if not, what prevented the use of that MQT.
给出用于确定查询是否使用了MQT的提示和技巧,如果未使用,是什么防止了MQT的使用。
Query optimization features using hints, explain plans, and profiling.
使用提示、解释计划和分析的查询优化特性。
Hints and tips on why a query is not using an MQT.
关于查询为什么不使用MQT的提示和技巧?
Provides helpful hints and tips on how to tune the performance of a distributed query in a federated system.
提供关于如何调优联邦系统中一个分布式查询的性能的提示和技巧。
Hence, it is not a good idea to use hints unless the tables are analyzed or you are fully hinting the query.
因此,除非这些表都被分析过或你给了查询完全的提示,使用提示不是个好办法。
Hence, it is not a good idea to use hints unless the tables are analyzed or you are fully hinting the query.
因此,除非这些表都被分析过或你给了查询完全的提示,使用提示不是个好办法。
应用推荐