Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Query Processing » Query optimization and execution » Query execution algorithms » Table access methods


RowIdScan method (ROWID)

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.

See also