Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: DB2 LUW

Finding the access path for Columnar queries #3

Published March 13th, 2018 - by

In the first blog in this series ( Finding the access path for Columnar queries ) I was griping about not being able to see any detail in the explain plans for what DB2 is doing when you see a table scan (TBSCAN) of a column-organized table. I mention that each columnar table will have Continue Reading

Finding the access path for Columnar queries #2

Published November 8th, 2017 - by

Usage Lists In my last blog ( http://db2geek.triton.co.uk/finding-access-path-columnar-queries ) I was reiterating the case for columnar data storage but bemoaning the lack of any means to see in the access path how the data is being retrieved. It merely shows as a table scan (TBSCAN) and you need to trust that what is going on Continue Reading

Finding the access path for Columnar queries

Published October 18th, 2017 - by

Columnar Data : how it works We’re probably all fairly familiar now with BLU acceleration and the advantages of storing analytical data in a columnar format. If not, and by way of a recap; what we can now do is return much smaller results sets to our analytical queries, in a highly-compressed format, thereby reducing Continue Reading

Do the Needful

Published July 19th, 2017 - by

So the last few blogs have been a bit negative and have been built around common expressions and assumptions that make my hackles rise (If it ain’t broke, don’t fix it, We’re Risk Averse and Best Practice). Now this is the blog with the positive spin, so it might seem strange that I’m hanging it Continue Reading

Next Page »