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 #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