0

"Index is also maintained in the transaction log"

Does this mean when a table having an index is queried, the entire index is pulled into the memory and subsequently logged into tlog?

1 Answer 1

8

No, querying things does not write data to the transaction log. The transaction log is the log of changes to your database.

When you update an indexed column, the index is updated. The changes this makes to the index are logged in the transaction log the same way that the changes made to the table are logged. This is because if your database was to crash, your indexes need to be recovered too.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.