开发者

SQL Server: Are physical operations rolled back after ROLLBACK?

开发者 https://www.devze.com 2023-03-14 06:35 出处:网络
What are the effects of ROLLBACK TRANSACTION on physical ordering开发者_JS百科 of data in pages? Are physical operations also rolled back when ROLLBACK is addressed?Based on these articles by Paul Ran

What are the effects of ROLLBACK TRANSACTION on physical ordering开发者_JS百科 of data in pages? Are physical operations also rolled back when ROLLBACK is addressed?


Based on these articles by Paul Randal and SQL Fool I'd say "no": on-disk layouts are not rolled back

These are about page splits, but a page split will affect physical ordering of the clustered index (not logical ordering though).

Note: there is never any guaranteed order without an ORDER BY (just in case)

0

精彩评论

暂无评论...
验证码 换一张
取 消