• Oof! fluked this one.

    Knew the first 2 were right, and that columnstore was non-clustered. Guessed it was probably an XML index and decided "for value" would be more useful.

    Phew! 🙂

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]