question

Mario2286-5314 avatar image
0 Votes"
Mario2286-5314 asked ·

Index Insert Operator

Need you advice guys if this index insert operator is normal or anything need to tune to avoid this operator below

76283-image.png



I believe this index insert is normal if the query was inserting a data to a table

Appreciate you advice

sql-server-general
image.png (17.0 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
1 Vote"
AmeliaGu-msft answered ·

Hi @Mario2286-5314,

It is normal. It will happen when the rows are inserted into the non-clustered index. Please don’t worry about it. Please refer to Operator List which might help.
Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TiborKaraszi avatar image
1 Vote"
TiborKaraszi answered ·

Yes, it is normal.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.