Index Insert Operator

Mario2286 441 Reputation points
2021-03-10T08:47:31.973+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,707 questions
0 comments
Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-03-11T02:38:12.34+00:00

    Hi @Mario2286 ,

    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

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. tibor_karaszi@hotmail.com 4,301 Reputation points
    2021-03-10T08:52:43.45+00:00

    Yes, it is normal.

    1 person found this answer helpful.
    0 comments