This is part 2 in the series that focuses on improving performance in Db2 Warehouse databases. The first part gave some background and discussed some basic concepts relevant to query optimization in the context of the Db2 column engine.
Part 2 : Identifying Costly Operations + Improving Joins
Since the beginning, I/O has been one of the main determining factors for overall performance. I/O can easily surpass all other considerations, particularly if an SQL statement asks for a very large result or a missing index causes the scan of a very large table.
In this video demo, you can learn how you can run Machine Learning algorithms in Db2 with a case using IBM Watson Studio running a Linear Regression model.
During the month of March, we focused on Db2 LUW, where we briefly touched the new world of the Cloud: Concepts you need to know and architectures you might want to try. Be sure to check out our content :)
In this article, we will learn about how Db2 Warehouse on Cloud Flex and how its architecture can deliver high availability by leveraging several solutions, including container management.