stable ordering

An order of results that is the same every time the same request is made, which pagination depends on.

In more detail

If the default order is left implicit, the database may choose a different plan and return a different page for an identical request. Document a default order and always finish it with a unique tie breaker.

Related terms

Taught in

References