Skip to Content
0
Nov 03, 2020 at 02:17 PM

Cannot directly insert into or update computed column

119 Views

Hello Experts,

Can someone explain impact of function based index on INSERT statement ?

Why below error coming while inserting data into table,

Error:

Cannot directly insert into or update computed column

Function based index on column of table :

Create Index userIndex1 on User (UPPER(user_name ))

I would appreciate all of your inputs and exact details.

Thanks in advance