I have a table TableA
with a computed column FieldA
bound to a function that returns a float. The function is GetFieldA
which calls two sub functions.
I also have a view which includes the GetFieldA
function not the computed column value as a field. I just tried to add a index to the view which said it required GetFieldA
to be schema bound in order to have a index on it, I changed it to be schema bound (which involved removing the computed column) but then when i went back to try to readd the computed column it said in order to use the GetFieldA
the schema bound must be removed.
Is there any way to have a computed column with a schema bound function or do i need to rework how im getting the field in order to be able to have a view index?