然后,优化器可以将输入变量的值与编目统计进行比较,并为谓词计算出一个更好的选择估计。
The optimizer can then compare the input variable values to catalog statistics and compute a better selectivity estimate for predicates.
要删除的该组用户作为谓词参数输入,但最好使用上下文变量。
The set of users to be removed is entered as verb parameter, preferably using context variables.
要删除的该组用户作为谓词参数输入,但最好使用上下文变量。
The set of users to be removed is entered as a verb parameter, preferably using context variables.
视图可以在谓词中使用该全局变量的值,从而只选择分配给用户所在部门的行。
A view could use the value of this global variable in a predicate to select only those rows for which the user's department is assigned.
如果不存在此谓词,任务编辑器将使用EmailAddressforUsersbyuserid谓词,并将其作为输入参数传递到变量%htm: escalation .receivers %。
If such a verb is not available, the task editor will use the Email Address for Users by user ID verb, and pass it the variable % HTM: escalation.receivers % as an input parameter.
本文提出了一种基于目标的方法,可以找到更多的候选方案,当查询的内置谓词只包含特征变量时该方法更加有效。
It can find more candidate solutions, and is more efficient when the built-in predicates of the query involve only distinguished variables.
本文提出了一种基于目标的方法,可以找到更多的候选方案,当查询的内置谓词只包含特征变量时该方法更加有效。
It can find more candidate solutions, and is more efficient when the built-in predicates of the query involve only distinguished variables.
应用推荐