mardi 26 avril 2016

What is the LOP_INSERT_ROWS and LOP_DELETE_ROWS operation on a View object?

I'm examining the MS SQL Transaction Log for investigating a problem, and found there are a huge amount of LOP_INSERT_ROWS and LOP_DELETE_ROWS operations on a SQL View object within a single "user_transaction" last for over a minute.

I just curious what is the meaning of a LOP_INSERT_ROWS and LOP_DELETE_ROWS operation on a View object? Do they mean the action on creating and dropping a View object?

Thanks.

Aucun commentaire:

Enregistrer un commentaire