RowIdScan is used to locate a row in a base or temporary table based on an equality comparison predicate that uses the ROWID function. The comparison predicate may refer to a constant literal, but more commonly the ROWID function is used with a row identifier value returned by a system function or procedure call, such as sa_locks.
RowId scans appear in the short and long text plan as
correlation-name<ROWID>, where correlation-name is the correlation name specified in the FROM clause, or the table name if no correlation name was specified.
It is impossible for RowIdScan to differentiate between an invalid row identifier for the given table referenced by the ROWID function, and a situation where the given row identifier no longer exists. So, RowIdScan returns the empty set if the row identifier specified in the comparison predicate cannot be found in the table.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|