• ScottPletcher (1/24/2013)


    HowardW (1/24/2013)


    There's no need to make the column persisted prior to indexing it.

    That's not necessarily always true. You might persist a column if its requires significant overhead to generate the value.

    I think you've misunderstood my comment. You need to read the whole sentence, including the bit I've highlighted. Whether it's persisted via an index or in the column definition, it's still only calculated on modification.