"Jack Orenstein" <[EMAIL PROTECTED]> writes:
> I understand that updating a row of t generates a new row version, and
> that different transactions may see different versions of the same
> row.
> How does versioning work for the index?
Each row version has its own index entry pointing to it. So a
On Thursday 28 September 2006 14:58, "Jack Orenstein"
<[EMAIL PROTECTED]> wrote:
> How does versioning work for the index?
>
> - The update above does not update the index key. Does the index get
> updated at all?
>
Yes, it does.
> - If not, then how can an index lookup return the correct vers
Suppose I have a table and index:
create table t(x int, y varchar, primary key(x));
and that the only updates are "update t set y = ... where x = ?".
I understand that updating a row of t generates a new row version, and
that different transactions may see different versions of the same
row.
