• Actually, the included columns make the leaf index entries larger. Therefore, fewer entries per page, which translates to more B-tree above. So there is a size cost for the entire tree structure based on the percent increase in size in the index entry. Increase in tree depth and seek time will be logarithmic increase.

    Still, well defined include columns can yield a big improvement.

    David Lathrop
    DBA
    WA Dept of Health