Initialize the scrolling window to the first 7 entries is easy: OFFSET gives the correct answer.However, OFFSET requires time proportional to the offset value.
Indexing is deferred until there is a search request.
If you want to update a single field on multiple records to have the same value, the list editor is the quickest method.
If you want to edit multiple fields or fields that do not appear in the list view, use an editing form.
Because of this indeterminacy, referencing other tables only within sub-selects is safer, though often harder to read and slower than using a join.  Set the value of column C1 in table T to 1, only in those rows where the value of column C2 is "a".
clause; columns not explicitly modified retain their previous values.