"johncr0181" <johnc@...> wrote:

>
> "Sort record size of <number> bytes is too big"

The entire record is processed by the sorter module, so if you select all
fields of many joined tables you'll obviously hit the record size limit.

> I'm not sure where to start looking to resolve this any ideas would
> be gratefully appreciated.

Make sure all fields/expressions inside your select list occupy less than
64K bytes.


Dmitry