Defining a strict sequence, as in a waterfall model, is just as much a process as defining a semi-ordered sequence of iterations in parallel work.
Create an ordered sequence (array) of business items by setting the minimum and maximum values for the item attributes.
If all the columns in the clause appear in the required sequence with a single index, the database server USES the index to read the rows in the ordered sequence, thus avoiding a sort.
Collate: (1) To arrange cards, sheets of paper or data into an ordered sequence. A machine performing this type of works is called a Collator.