In order to force the behaviour of a particular mode (local vs remote) on a query by query basis, a query hint must be changed.
为了对某个查询强制一个特定模式(本地与远程)的行为,必须更改查询提示。
Use the RECOMPILE query hint when atypical or temporary values are used in only a subset of queries that belong to the stored procedure.
如果非典型值或临时值仅用于属于存储过程的查询子集,则使用RECOMPILE查询提示。
Moreover, Hibernate USES this setting as a database hint against certain database types for optimized query performance.
而且,Hibernate将此设置用作针对某些数据库类型的数据库提示从而优化查询性能。
Listing 16 gives an example of a query where the optimizer is given the hint that the spatial predicate will only have very few qualifying rows.
清单16给出了一个查询例子,在这个查询中,向优化器提示空间谓词只有很少的符合条件的行。
Limit query and index hint use.
最小化查询和索引暗示。
Limit query and index hint use.
最小化查询和索引暗示。
应用推荐