>>>>> "Rick" == Rick Moore <lrmoore@stripped> writes:
Rick> I did a search on the manual and couldn't find any information on this
Rick> keyword. I understand when it should be applied :) but what does it do?
I have now updated the MySQL manual with the following:
SQL_BIG_RESULT can be used with GROUP BY or DISTINCT
to tell the optimizer that the result set will have many rows. In this case,
MySQL will directly use disk based temporary tables if needed.
MySQL will in this case prefer to do a sort instead doing a
temporary table with a key on the GROUP BY elements.