Originally posted by fossil
The queries with the full table scan do not have any problems, the output comes as already sorted by custnum.
As Chris says, there is no such thing as pre-sorted data. This "accident" with FTS will certainly break down if you try to speed things up with Parallel Query.