For comparison, Figure 3 illustrates the access plan where I forced the DB2 optimizer to ignore the index by adding the clause SELECTIVITY 1 to the predicate in the where clause.
Note that the join predicate on the author ID does not contain a literal value that would indicate the data type of the comparison.
请注意,author ID上的连接谓词没有包含文字值,该文字值将表明比较的数据类型。
3
Now, if I may continue, once the CompareOther function has been written, the faithful needs only to write a binary predicate to wrap the comparison function.