Thanks guys for the suggestion.

The other way I can think of is put that pre-comput column into a temp table (with the other columns).

Then I create an index for the...