InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is A Ctid? |
|
Answer» CTIDs identify SPECIFIC physical rows by their block and offset positions within a table. They are used by INDEX entries to point to physical rows. A logical row's CTID changes when it is updated, so the CTID cannot be used as a long-term row identifier. But it is sometimes useful to identify a row within a transaction when no COMPETING UPDATE is expected. CTIDs identify specific physical rows by their block and offset positions within a table. They are used by index entries to point to physical rows. A logical row's CTID changes when it is updated, so the CTID cannot be used as a long-term row identifier. But it is sometimes useful to identify a row within a transaction when no competing update is expected. |
|