Playing with cardinality and selectivity on predicates is not a common trick, though Joe Geller, David Simpson and Tony Andrews demystify it so that you can start playing with its intricacies and give a boost to the Optimizer.
Automated application testing for web services with a Db2 repository is not an easy task, and it invites for creative solution. On this post, David Morris shows how this can be accomplished with the aid of tools like Jenkins and H2 as a means of providing a test scenario that mirrors a Db2 database.
En este artículo, exploramos el concepto de REST, en donde veremos por qué es importante, y lo que debemos saber para comenzar a trabajar con servicios RESTful.
I recently worked with an insurance company on an interesting issue involving dates. They had a series of records that all had a start date but no end (or cancel) date. The end date of a record was implicitly recognized as the start date of the next highest record. This article will show you how.
A temporary table is a place to store relevant to your needs. Whether you are an application or some end-user. It is a place to keep data. It helps give SQL coding options. They can help reduce SQL complexity! You can break down complex SQL into smaller SQL chunks via temporary tables.