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给出了一个查询例子,在这个查询中,向优化器提示空间谓词只有很少的符合条件的行。
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给出了一个查询例子,在这个查询中,向优化器提示空间谓词只有很少的符合条件的行。
应用推荐