Position-based access in key sequence need not scan all stored rows. The sequence of rows can be limited in two ways:
- The usage of a view name has the effect that not all rows of a particular table are visible.
- A WHERE condition defines additional conditions on the row in question.
SELECT LAST name FROM city
WHERE state = 'CA'
SELECT NEXT name FROM city KEY zip = 20037
WHERE state = 'CA'
