This means that several asynchronous reads complete out of order (as discussed before in section 3.6.2), and byte chunk streams returned by the pending reads will not be processed in order.

意思是很多异步读无顺序完成(像在3.6.2讨论的)，通过异步读操作无序的返回字节块流。

This control is provided in the form of the ORDER BY clause in conjunction with the order in which table qualified column names appear in the query elements table.

这种控制通过 ORDER BY 子句以及表合格列名称在查询列表格中出现的顺序实现。

The row order in the query elements table in which columns are defined determines their left to right sequence within the order BY clause, which in turn determines their sorting priority.

定义了列的查询元素表中的行顺序决定了它们在ORDER BY子句中从左到右的顺序，这又确定了它们的排序优先级。

The Resequence node lets messages arrive in any order, but will only propagate messages in the correct order (which can be determined by any source, including the sequence node).

反序列节点让消息以任意次序到达，但仅传播按照正确顺序排列的节点(该顺序可以由任意源确定，包括序列节点)。

However, for now, I will simply show how to save two clock cycles by adjusting the order of the selb and STQD instructions. Here is the new order.

不过对于现在来说，我们将简单地展示如何通过调整selb和stqd指令的顺序来节省两个时钟周期。