HowardW (1/25/2013)
ScottPletcher (1/24/2013)
Seems an odd way to read it in context here, since the OP stated in his original post that he could index a computed column w/o explicitly persisting it. I guess I just didn't understand why that needed to be restated separately.I was addressing the statement the OP quoted from the MS documentation that, out of context, suggested that you were required to mark a column as persisted before indexing it.
Is there any specific technical reason for this suggestion. As we are able to create index without making the computed column as PERSIST. Only the difference is the execution plan for the both is different, there is extra computed column icon in execution plan for without PERSIST case.
🙂