Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: columnar

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