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
Advanced JSON Understanding how to Exploit Db2 Capabilities in the NoSQL World by George Baklarz

IBM Db2 Editions Simplified for Straightforward Deployment Options

Db2 Architecture Overview and BLU