INSERT INTO x SELECT SQL_BIG_RESULT?

[Mark Modrall]

Hi...

I've started experimenting with using SQL_BIG_RESULT on some queries and have found for large result sets it improves performance dramatically. But I was wondering - on INSERT ... SELECT statements would there be a similar benefit or is the server going to get some optimization out of knowing it's stashing the result in a table as it goes anyway? I know it allows you to put SQL_BIG_RESULT on an INSERT ... SELECT statement, but I haven't done experiments to see if it might pay off and under which circumstances.

Thanks
_mark