Early stage predicate evaluation with DECFLOAT and implicit casts

Indexable and/or stage 1 predicates can be evaluated at the early stage during row retrieval. There are multiple factors that can affect the stage of predicate evaluation, for example, the data type and length of the operands, the syntax of the predicate, the join sequence, etc. This article is focused on how Db2 query optimization can be used to achieve early stage evaluation whenever possible for predicates with DECFLOAT and implicit string to numeric type conversion. This article is about the DECFLOAT function and its performance improvements. 

Click here to read the full article. (IDUG login required). https://www.idug.org/p/bl/ar/blogaid=883

 

 

 

1 Like
Recent Stories
December Content Recap

Anomaly detection with SQL on Db2

November Content recap