Ordering

Base Table Order

Start with the visible input row order.

highlighted = computed this step

Base table order

Before sorting, the rows appear in their pinned input order.

input order\text{input order}

Show the input order

The base table has 3 rows, and the page shows 3 rows.

rows=3\text{rows}=3

Ordering examples are tiny finite table transforms; SQL dialects, NULL ordering, collations, indexes, optimizer behavior, performance, and product behavior are out of scope.

Base table order: base tablesourceRowidkindscore01book3012game1023tool20 order bycolumndirectionnoneinput order sort keyssourceRowkey0[]1[]2[] ordered rowssourceRowidkindscore01book3012game1023tool20 page rowssourceRowidkindscore01book3012game1023tool20 tie groupskeysourceRowsnonenone order factsfactvaluerowCount3orderColumnCount0orderedRowCount3offset0limitnonepageRowCount3skippedBeforeCount0skippedAfterCount0unstableTiesnodeterministicTieOrdernot_needed

Read sourceRow

The sourceRow column makes the original row position visible.

sourceRow tracks input\text{sourceRow tracks input}

Summary

This first view is the table as authored, not a hidden sort.

no ORDER BY yet\text{no ORDER BY yet}