• Nice question, but just one small problem:

    "In prefix compression, does the entire prefix stored in the header need to match the data to be used?"

    --> requires the answer NO to be correct

    "In other words, if I have a prefix of "aaabcd" in the header and a data element of "aaabfgr" in a field, can prefix compression be applied?"

    --> requires the answer YES to be correct

    I chose NO, but apparently that was the wrong one, although I meant to answer the first question.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP